How to Remove #Value error

[pmbixler]

Hello,

I have the formula =K3-Q3/1.45 entered into cell R3, I have filled the entire column with the formula but I am getting the #Value error message. What do I do to make it blank? I was able to use IFERROR function do it for forumlas where I'm using multiplication but I can't see to figure it out for when I use division.

Thank you!

[Norie]

It shouldn't matter what your formula is when using IFERROR.

Does this not work?

=IFERROR(K3-Q3/1.45, "")

[pmbixler]

No it gives me the wrong total.

My math is as follows: $32,500 - $8950 = $23,550
$23,550/1.45 = $16,241.38

Where $32,500 is cell K3, $8950 is Q3, and $16,241.30 is in cell R3.

When I put in your formula, I'm getting $26,327.59.

[TMS]

You need

Please Login or Register  to view this content.

[The_Snook]

Hi pmbixler,

Try:

=IFERROR((K3-Q3)/1.45, "")

It's due to something called the 'order of operations' in Excel. In this instance it calculates the division before the subtraction, i.e. $8,945/1.45 and then subtracts that amount from $32,500.

Hope this makes sense?

Regards,

Snook