- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2007 August
- Formula displays in cell

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.

- RE: Formula displays in cell posted by Gary''s Student on Fri, 31 Aug 2007
- RE: Formula displays in cell posted by BJ on Fri, 31 Aug 2007