Formula displays in cell
There are two reasons the formula would display in a cell as well as the
formula bar:
1. the display mode is formula. Fix this by touching CNTRL-`
2. the cell was formatted as Text prior to entering the formula. Fix this
by clearing the cell (including formats) and then re-entering the formula
A third possibility is that an apostrophe was entered before the = sign
--
Gary''s Student - gsnu200741
"Richard Ward" wrote:
I am writing a multi-step formula, once I get to a certain point I loose the
calculation in the cell and the formula is displayed. How do I keep this from
happening? The formula is :
=$D$3*(VLOOKUP(G51,Territory,2,FALSE))*VLOOKUP(A47 ,CLASS,2,FALSE)*G3
Even if I simply change the reference on cell G3 to absolute, I get the same
result, the formula displays, not the result.
|