Lotus to Excell

G

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
(e-mail address removed)
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to refer to a criterie in a cell using excel sum.if function 3
Cell subtraction 3
Expression 3
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Date Time increment with additional condition of skipping weekends 18
Merging from an Excel file with graphics 1
Changing the result of a formula to a real number. 2
Nested If with Lookup 1

Top