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

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

Thanks for your elegant solution (short & simple)




"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