Question about ISBLANK function
Posted by Carol on January 11, 2002 9:01 AM
Can anybody help me on this?
Cell A1 of my spreadsheet has the formula =if(isblank(b2),1,0). The formula returns 1 if cell b2 is blank and a zero if cell b2 has a value. The problem I have is that cell b2 contains a formula. Sometimes this formula results in b2 appearing blank. But cell A1 always sees the formula and therefore always returns a zero.
How can I get A1 to return a 1 if B2 appears blank even though B2 has a formula in it?
Hope that makes sense!