My formula IF(E5<G5, "Not Equal", "Equal") will only give the message "Not
Equal" even if the values are equal, however if i copy the formula into a new
worksheet and the values are equal it will return the Correct value of
"Equal".
Thanks for your help.