ISBLANK inconsistent with results

R

RBolton

I'm using ISBLANK to blank the cell if the cell referred
to is empty, for example:
=IF(ISBLANK('Input Items'!BR132),"",'Input Items'!BR132)

However, I'm getting inconsistent results when the cell
referred to also contains a formula. Let's say that CG131
contains a formula, and the formula refers yet another
cell (for example =A43)which is empty (A43 is empty that
is). I have one worksheet with the above ISBLANK formula
where the result is apparently False because the cell
stays empty, but I have another worksheet (in the same
spreadsheet) which also contains the exact same ISBLANK
forumula and it always shows a 0. Can't figure out why
the difference. Is there a way to blank a cell whose
formula refers to another cell that also contains a
formula?
 
E

Earl Kiosterud

R,

Check Tools - Options - View - Zero values for each sheet containing the
formula.
 
R

RBolton

Now why in the world is that so hidden (<; I have search
the help file with everything I could think of and that
never showed. Thanks!!!!!
 
E

Earl Kiosterud

R,

The options in Tools - Options apply in some cases on a sheet basis and in
others, workbook, and others, Excel-wide. Keeps us on our toes, don't it?
 
J

Jon Peltier

An alternative to Earl's suggestion:

=IF(LEN('Input Items'!BR132)=0,"",'Input Items'!BR132)

Whether it's blank or another formula's "", it returns its own "".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top