I have 'asked' Excel to divide two cells (each cell has been set to "number;
2 digits")
The numerator is a cell that refers to another cell, where the value of the
original cell entered states 15000 (number, 2 digits); the denominator refers
to a cell that is a formula that states .67, but this is a reference to two
other cells that produce that number. All of my manual calculators state the
value should be 22388, but Excel states the value as 22500?? What have I
done wrong??
NOTE: when I manually type in .67 into the formula cell the resulting value
correctly shows 22388 -- so it must be because of the multiple reference--but
it does give me a circular reference error.
(I thought this may have been because I originally created the worksheet in
Excel 97; so I saved it into Excel 2003--still no affect)
If you would like the file, please e-mail me direct and I will send it
along:
THANKS SO MUCH!