G
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
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