Lotus to Excell

[gudway]

In Lotus123 there used to be an expression
@if(A17>"","The cell is NOT blank","The cell IS blank")
How can I do this in Excell !
Thanks
[email protected]

 

[Gazzr]

Hi Mate,

Try this one. Paste the forumla below to cell C25 with the cell to be
tested as D25.

It just tests the number of chars in cell D25

=IF(LEN(D25)>0,"NOT BLANK","BLANK")

Thanks
gazzr

 

[gudway]

Thanks for your elegant solution (short & simple)
[email protected]