Negative Values resulting in error

[KKD]

I have a formula set as follows:

=if(c27=v19,(v19),("Error"))

The formula works fine until the value becomes a negative number, then it
returns as a false "Error" even though the values are still equal. How can I
resolve this?

 

[RagDyer]

Try either of these, depending on what you want displayed:

=IF(ROUND(C27,2)=ROUND(V19,2),V19,"Error")

OR

=IF(ROUND(C27,2)=ROUND(V19,2),ROUND(V19,2),"Error")

 

[Gord Dibben]

Use the ROUND function or set Precision as Displayed.

Note the second option affects ALL cells.


Gord Dibben MS Excel MVP

 

[Luke M]

You can use the ROUND function.

=IF(ROUND(C27,2)=ROUND(V19,2),V19,"Error")
or
=IF(ROUND(C27,2)=ROUND(V19,2),ROUND(V19,2),"Error")
depending on how precide you want the resultant to be.