View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
emprof emprof is offline
external usenet poster
 
Posts: 8
Default 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