I have an Excel sheet where I'm using the =IF(ISBLANK) and telling it to return a blank in another cell, otherwise add 2 cells together. When it does this, it is returning a zero instead of a blank.
The formulas I'm using are:
This is cell H3 =IF(ISBLANK($G3),"",RANK($G3,$G$3:G$56,0)) This one works properly and the cell is blank because there is nothing in call G3.
=IF(ISBLANK($H3),"",($G3+$I3)) This one references cell H3 where the above formula lives and isn't working, it returns a 0 and I need it to return a blank.
What am I missing?
Bookmarks