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.

If Statement not recalculating
 

try:

Tools=Options=Calculation=Check 'Automatic'

"Bagia" wrote:

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.

If Statement not recalculating
 

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

Also, use this formula instead:

=MAX(C2-B2,0)

"Bagia" wrote:

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.

If Statement not recalculating
 

thank you all for responding.

"Duke Carey" wrote:

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

Also, use this formula instead:

=MAX(C2-B2,0)

"Bagia" wrote:

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.