| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My formula displays just as it is, instead of calculating
I'm working with a spreadsheet that was passed to me, and I haven't created
it from scratch. I've added a column and created a simple formula that simply displays in the cell instead of showing me the calculated result. I've checked that automatic calculation is ON. The cell simply displays =IF(D2=8,E2,"") instead of showing me the value of cell E2 or the empty value. I've also tried various other formula; they all behave similarly. I can't imagine what would cause the formula to display, almost like it's being considered as a text string..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Formula displays result in formula box but not in cell | Excel Discussion (Misc queries) | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| cell displays formula | Excel Discussion (Misc queries) | |||
| Cells displays formula, not results | Excel Worksheet Functions | |||
Threaded Mode
