Forum Discussion

Copper Contributor

Feb 26, 2020

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...

excel

JoeRock

Copper Contributor

Feb 29, 2020

Riny_van_Eekelen Thank you so much for all your help. It worked, but I wanted the original values of 0 for C4 & $0.00 for C5 to be present even when C2 & C3 were blank. I figured out by putting the values in the quotes that it does the job. So this is what they look like now.

C4: =IF(OR(ISBLANK(C2),ISBLANK(C3)),"0",(C3-C2)/0.25)

C5: =IF(OR(ISBLANK(C2),ISBLANK(C3)),"$0.00",C4*12.5)

It seems to work. If you see anything wrong with it please let me know.

Again thanks so much for your help!!

Riny_van_Eekelen

Platinum Contributor

Feb 29, 2020

JoeRock That would work fine. Though, putting the 0 or the $0,00 between quotes ("") makes them texts. You can skip the quotes if you want to return the number -zero- (formatted as $, if you want) as values.

Riny_van_Eekelen
Platinum Contributor
Mar 01, 2020
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.
JoeRock
Copper Contributor
Feb 29, 2020
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