I am using IFERROR and I want my error argument to be a blank.
My formula is =IFERROR(Statement being evaluated,"")
If there is an error, then the cell appears as a blank. The problem is if I perform a mathematical operation on the cell, I get #VALUE.
If I perform a mathematical operation on a cell that is actually blank, the cell acts as a 0.
I don't want to use 0 as the error argument. Is there a way to do this?
Hi David,
I don't know of a way you can do this, however if the issue is that you don't want to see zeros in your spreadsheet, then you could use a custom number format to hide them e.g. 0;-0; will only show positive and negative values greater than or smaller than zero. Any zero values will be displayed as a blank cell.
This way you can use =IFERROR(Statement being evaluated,0) and math operations on the result will still work.
More on hiding zeros with custom number formats here.
Mynda
If I am understanding you correctly, it sounds like you don't want a calculation performed if a cell is blank? If that is the case, a simple IF statement should do the trick.
=IF(cell your evaluating<>"",calculation,"")
If your cell is not blank then do the calculation, otherwise display a blank cell (Or whatever you are needing done if the cell is blank).
