isblank
 

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

isblank
 

Try this:

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

Hope this helps.

Pete

On Dec 18, 4:15*pm, James Irwin
wrote:
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

isblank
 

Hi James

Use IsNumber.

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

Regards,
Per

"James Irwin" skrev i meddelelsen
...
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