Logic Function

[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.

 

[John Wilson]

Paul,

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

John

 

[J.E. McGimpsey]

one way:

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

another:

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

or:

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

 

[Paul Axelrod]

Three good suggestions.
Thanks guys!!

one way:

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

another:

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

or:

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