software

I am trying to do an IF function with either AND or OR, and so far it is not
given me the right answer, please help. If the first letter of cell A1 is 1
or D, then blank, or else A1

=IF(OR(LEFT(A1,1)=quot;Dquot;,VALUE(LEFT(A1=1),quot;quot;,A1))

Ania Ziolkowska
2006-01
DayTotal
1/17/2006
DayTotal
1/16/2006
=IF(OR(LEFT(A1,1)=quot;Dquot;,VALUE(LEFT(A1))=1),quot;quot;,A1)
This should return A1, but if you need a numeric result, you've still got
some work to do...

quot;Thuyquot; wrote:

gt; I am trying to do an IF function with either AND or OR, and so far it is not
gt; given me the right answer, please help. If the first letter of cell A1 is 1
gt; or D, then blank, or else A1
gt;
gt; =IF(OR(LEFT(A1,1)=quot;Dquot;,VALUE(LEFT(A1=1),quot;quot;,A1))
gt;
gt; Ania Ziolkowska
gt; 2006-01
gt; DayTotal
gt; 1/17/2006
gt; DayTotal
gt; 1/16/2006
gt;
gt;