If Statement not recalculating
Hello,
I have an If statement such as:
=IF(B2-C20,0,C2-B2)
Everything works well when I copy the formula to other cells below it. The
problem occurs if I change the value in column C to a higher value, the
result doesn't automatically recalculate. Does anyone know why?
Thanks in advance.
|