View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bagia Bagia is offline
external usenet poster
 
Posts: 46
Default 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.