Formula displays in cell

Giganews Newsgroups
Subject: Formula displays in cell
Posted by:  Richard Ward
Date: Fri, 31 Aug 2007

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.

Replies