| 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 |
| 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) | |||
Threaded Mode
