ExcelBanter - Lotus to Excell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lotus to Excell (https://www.excelbanter.com/excel-worksheet-functions/86745-lotus-excell.html)

gudway

Lotus to Excell

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

Gazzr

Lotus to Excell

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

gudway

Lotus to Excell

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

All times are GMT +1. The time now is 09:07 PM.