Negative Values resulting in error
I tested with -10 in both C27 and V19 and got -10 as expected...
"KKD" wrote:
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?
--
KKD
|