AUTO FILL Help urgent

[nabeeljeddah]

dear all
i am having a problem & i am sure its a minor one but i tried my level best but was not able to find any solution even over the net
well the situation is like that
i am having

two columns

A B C
12 6 =(A1-B1)/B1

Now here the Column A & Column B are fill with values and column C is having a formula when i drag down for auto fill it is not calculating as it goes down with respect to its values in column A & B where as it repeats down the result in coulmn C which came in the first row.
please any 1 can help me as its really urgent i already did wat ever it was in my resource
THANKSS

REGARDS,
NABEEL

 

[ageren]

check your calculation option in your worksheet;

tools > options > calculation > [ calculation - automatic option button should be marked ]