Autofill on Formula Not Working - blowing my mind

[Guest]

This is the first time I have run into this issue. I have written a formula in excel. It calculates correctly, but when I drag it down for autofill it provides the same answer as in the first cell, yet the formula is relative to that cell and row (as it should be). So I closed the worksheet, reopened and tried again. Same problem. So I opened a different workbook where I know I have a bunch of formulas. I mock the formula in this worksheet, plus some others and they all autofill correctly

Here's a quick sample of data from it (assume columns are relative to the data): The formula for the third column reads like this "=if(B1="CR",-A1,A1)". If I test the formula in the row and cell with a "CR" and do not autofill it works
A B
281 28
323 CR 28
291 28
169 CR 28

Thanks...steve

 

[Jason Morin]

Check to see if you workbook is set to manual calculation
under Tools > Options > Calculation tab.

HTH
Jason
Atlanta, GA

-----Original Message-----
This is the first time I have run into this issue. I have

written a formula in excel. It calculates correctly, but
when I drag it down for autofill it provides the same
answer as in the first cell, yet the formula is relative
to that cell and row (as it should be). So I closed the
worksheet, reopened and tried again. Same problem. So I
opened a different workbook where I know I have a bunch of
formulas. I mock the formula in this worksheet, plus some
others and they all autofill correctly.

Here's a quick sample of data from it (assume columns are

relative to the data): The formula for the third column
reads like this "=if(B1="CR",-A1,A1)". If I test the
formula in the row and cell with a "CR" and do not
autofill it works.