J
JCLSB
Hello,
I have a client who uses excel and has a problem with creating auto
formulas.
She creates a formula such as =ROUND(D5*$G$5,2) and it works fine. She then
grabs the lower corner and drags it down to the rest of the columns and the
resutl is the same answer as the original cell. When you look at the
formula for each cell they are correct (the correct formula indicating the
correct row). If you go to the formula bar and place the cursor behind the
formula and press enter the correct result is then displayed for that cell.
You have to do that for every cell for the answer to be correct. The
version is Excel 2002 SP3. I ran a detect and repair and even reset the
default settings with no change.
JCLSB
I have a client who uses excel and has a problem with creating auto
formulas.
She creates a formula such as =ROUND(D5*$G$5,2) and it works fine. She then
grabs the lower corner and drags it down to the rest of the columns and the
resutl is the same answer as the original cell. When you look at the
formula for each cell they are correct (the correct formula indicating the
correct row). If you go to the formula bar and place the cursor behind the
formula and press enter the correct result is then displayed for that cell.
You have to do that for every cell for the answer to be correct. The
version is Excel 2002 SP3. I ran a detect and repair and even reset the
default settings with no change.
JCLSB