Logic Function

P

Paul Axelrod

I am attempting to create an IF function which test whether or not a
cell is empty. If the cell contains data, it will contain a text
entry.
The form I need it to take is if(A1 is empty, "--", C1*0.005).
I am not sure how to specify the IS EMPTY test of the contents of A1.
Thanks for any help.
 
J

J.E. McGimpsey

one way:

=IF(ISBLANK(A1),"--",C1*0.005)

another:

=IF(ISTEXT(A1),C1*0.005,"--")

or:

=IF(A1="","--",C1*0.005)
 
P

Paul Axelrod

Three good suggestions.
Thanks guys!!

J.E. McGimpsey said:
one way:

=IF(ISBLANK(A1),"--",C1*0.005)

another:

=IF(ISTEXT(A1),C1*0.005,"--")

or:

=IF(A1="","--",C1*0.005)
Click to expand...
 
Top