View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKD KKD is offline
external usenet poster
 
Posts: 31
Default Negative Values resulting in error

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