isblank

[James Irwin]

hi - i'm trying to use the isblank formula to return "1" if the referenced
cell is blank and "2" if not. However, the cells i'm referencing are all
formulae, so the isblank function returns "2" even if the cell "looks" blank
(i.e. "" has been used in a formula so cell text is blank but formula is
picked up by 'isblank'). So basically, i'm either i) looking for an
alternative to 'isblank' which only looks at the results/values of the cell
output or ii) looking for a way to make 'isblank' work with my reference
cells by changing the reference cells somehow (e.g. similar function to the
trim function)???

many thanks in advance.
james

 

[Pete_UK]

Try this:

=IF(A1="",1,2)

Hope this helps.

Pete

 

[Per Jessen]

Hi James

Use IsNumber.

=IF(ISNUMBER(A3),2,1)

Regards,
Per