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]



"Gazzr" wrote:

>
> 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
>
>
> --
> Gazzr
> ------------------------------------------------------------------------
> Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
> View this thread: http://www.excelforum.com/showthread...hreadid=538746
>
>