G
Guest
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.
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.