Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IsBlank | Excel Discussion (Misc queries) | |||
ISBLANK() | Excel Worksheet Functions | |||
isBlank() | Excel Worksheet Functions | |||
ISBLANK | Excel Worksheet Functions | |||
IF(ISBLANK) | Excel Worksheet Functions |