ISBLANK function???

  • Thread starter Thread starter Zilla
  • Start date Start date
Z

Zilla

Say I have this

1 2
A f1 f2
B ? ?

How do I leave B1 and B2 blank if their corresponding
f1 and f2 functions in A1 and A2 respectively are either
0 or blank. Again in psedo-code

A1=(if(blah), some_value, "")
B1=if(OR(ISBLANK(A1), A1=0), "", some_value)

Similar for A2/B2
 
B1=if(OR(ISBLANK(A1), A1=0), "", some_value)

How about this:

=IF(OR(A1="",A1=0),"",some_value)

Biff
 
Well, that ISBLANK function is incorrectly named! It should be named
ISEMPTY.

Just about everyone considers a formula blank ="" a blank cell (not an empty
cell) cell but ISBLANK doesn't.

Biff
 
Back
Top