TexasCHLforum.com

I need to use an if/then function dealing with an empty cell, but nothing I try works. Here is what I need to do:

If(A1 [not emply], A1,"XXX")

Any suggestions folks?

Thanks,
Chas.

some details as to why you want to put xxx in an empty cell might help
for alternative solutions

=IF(((A1)<>""),A1,"XXX")

Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")

ScooterSissy wrote:=IF(((A1)<>""),A1,"XXX")

Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")

Thanks, that worked!

Chas.