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.