Hi Richard

I have a spreadsheet if the following formulas.

Enter a value in cell B2.
Cell B12 has a formula: =B2/25
Cell B11 has a formula: =4+(2*B12)

This works great.

If cell B2 has no value, an empty cell, I want cell B11 to show blank or an empty cell. I tried using IF(ISERROR function. It works fine for the other cells, not this cell.
I’m thinking the formula in B12 is conflicting the IF(ISERROR function.

=IF(ISERROR(4+(2*B12)),"",4+(2*B12))


Thanks

---

Answer from Richard Rost:

You wouldn't use ISERROR. You could use ISBLANK:

=IF(ISBLANK(B2),"",X)

Where X is whatever you want this cell to read.