Forum Discussion
Hide error strings
Hi, I am trying to hide error string messages in a formula cell when it calls on data from a cell that is blank. The formula needs data from 2 cells and when I fill in 1 of the cells, the error messa...
In C4:
=IF(OR(ISBLANK(C2),ISBLANK(C3)),"",(C3-C2)/0.25)
in C5:
=IF(OR(ISBLANK(C2),ISBLANK(C3)),"",C4*12.5)
.... or see attached. Although, I note that C3 is not part of any of your formulae, so C3 being blank or not has no impact..
Edit: Corrected the first formula!
Riny_van_Eekelen Must have accidentally overwritten part of the formula in C4. Hence, my comment that C3 is not part of any formula.