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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula displays in cell
There are two reasons the formula would display in a cell as well as the
formula bar: 1. the display mode is formula. Fix this by touching CNTRL-` 2. the cell was formatted as Text prior to entering the formula. Fix this by clearing the cell (including formats) and then re-entering the formula A third possibility is that an apostrophe was entered before the = sign -- Gary''s Student - gsnu200741 "Richard Ward" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula displays in cell
at what point do you loose the value?
when you say the formula is displayed, do you mean that you can click on another Cell and work in it while the formula shows? if this is the case,check that the format of the cell is not text, if not try selecting the equal sign and replacing it with another equal sign.occassionally this fixes the problem you have. what happens when you use each portion individually in a formula ? "Richard Ward" wrote: 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. |
Reply |
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 |