| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Displays Instead of Result One Column Only
I have a spreadsheet where in one column only any formula I enter displays
as a formula and not as a result of the formula. In Tools | Options we do NOT have Formulas checkbox selected. Other columns in this spreadsheet resolve the formulas to values. In the one affected column the formula reads: =IF(H163=1099,"x","") What displays in the cell is the above formula as a string. What would cause a formula to not calculate a result for one column or cell only? -- W |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula displays instead of text result | Excel Discussion (Misc queries) | |||
| Cell displays formula and not result | Excel Worksheet Functions | |||
| Cell Displays Formula, not result | Excel Worksheet Functions | |||
| Cell displays formula, not result? | Excel Discussion (Misc queries) | |||
| Cell displays formula instead of result | Excel Discussion (Misc queries) | |||
Threaded Mode
