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...
Riny_van_Eekelen so then it would look like this?
C4: =IF(OR(ISBLANK(C2),ISBLANK(C3)),,(C3-C2)/0.25)
C5: =IF(OR(ISBLANK(C2),ISBLANK(C3)),,C4*12.5)
This way the cell retains it's number format. Is that correct.
Thanks JoeRock
JoeRock I meant this:
C4: =IF(OR(ISBLANK(C2),ISBLANK(C3)),0,(C3-C2)/0.25)
C5: =IF(OR(ISBLANK(C2),ISBLANK(C3)),0,C4*12.5)
and then display C5, using the Currency format, as dollar.