If Statement not recalculating

B

Bagia

Hello,

I have an If statement such as:
=IF(B2-C2>0,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.
 
D

Duke Carey

Make sure you have recalculation set to Automatic, under the meu for
Tools->Options->Calculation

Also, use this formula instead:

=MAX(C2-B2,0)
 
B

Bagia

thank you all for responding.

Duke Carey said:
Make sure you have recalculation set to Automatic, under the meu for
Tools->Options->Calculation

Also, use this formula instead:

=MAX(C2-B2,0)
Click to expand...
 
Top