| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Displays Formula, not result | Excel Worksheet Functions | |||
| Formula Displays in One Cell | Excel Worksheet Functions | |||
| Formula Displays in One Cell | Excel Worksheet Functions | |||
| cell displays formula | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Threaded Mode
