| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula displays instead of text result
Hi, I'm trying to change my formula
[=IF(AB291%,"A",IF(AB281%,"B",IF(AB271%,"C",IF(A B255%,"D",IF(AB2<55%,"F")))))], which works fine, but whenever I make any change or create the formula in another cell, only the formula appears, not the result. The result should be text, either "A," "B," "C," "D," or "F." I wanted to use 91.9%, 81.9%, etc. in revising my formula. I am using Excel 2007. -- emprof |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula displays instead of text result
Change the formatting of the cell from text to general. Select the cell, hit
F2 to enter edit mode and the hit enter to commit the formula... -- HTH... Jim Thomlinson "emprof" wrote: Hi, I'm trying to change my formula [=IF(AB291%,"A",IF(AB281%,"B",IF(AB271%,"C",IF(A B255%,"D",IF(AB2<55%,"F")))))], which works fine, but whenever I make any change or create the formula in another cell, only the formula appears, not the result. The result should be text, either "A," "B," "C," "D," or "F." I wanted to use 91.9%, 81.9%, etc. in revising my formula. I am using Excel 2007. -- emprof |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula displays instead of text result
Thanks very much. Your suggestion worked fine!
-- emprof "Jim Thomlinson" wrote: Change the formatting of the cell from text to general. Select the cell, hit F2 to enter edit mode and the hit enter to commit the formula... -- HTH... Jim Thomlinson "emprof" wrote: Hi, I'm trying to change my formula [=IF(AB291%,"A",IF(AB281%,"B",IF(AB271%,"C",IF(A B255%,"D",IF(AB2<55%,"F")))))], which works fine, but whenever I make any change or create the formula in another cell, only the formula appears, not the result. The result should be text, either "A," "B," "C," "D," or "F." I wanted to use 91.9%, 81.9%, etc. in revising my formula. I am using Excel 2007. -- emprof |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell displays formula and not result | Excel Worksheet Functions | |||
| Cell displays formula, not result? | Excel Discussion (Misc queries) | |||
| Function displays as text, doesn't return result or error | Excel Worksheet Functions | |||
| Cell displays formula instead of result | Excel Discussion (Misc queries) | |||
| Cell displays formula and not result | Excel Discussion (Misc queries) | |||
Hybrid Mode
