Formula displays in cell
 

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.

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.

Formula displays in cell
 

at what point do you loose the value?
when you say the formula is displayed, do you mean that you can click on
another Cell and work in it while the formula shows? if this is the
case,check that the format of the cell is not text, if not try selecting the
equal sign and replacing it with another equal sign.occassionally this fixes
the problem you have.
what happens when you use each portion individually in a formula ?

"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.