Formula displays instead of text result

  • Thread starter Thread starter emprof
  • Start date Start date
E

emprof

Hi, I'm trying to change my formula
[=IF(AB2>91%,"A",IF(AB2>81%,"B",IF(AB2>71%,"C",IF(AB2>55%,"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.
 
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...
 
Thanks very much. Your suggestion worked fine!
--
emprof


Jim Thomlinson said:
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 said:
Hi, I'm trying to change my formula
[=IF(AB2>91%,"A",IF(AB2>81%,"B",IF(AB2>71%,"C",IF(AB2>55%,"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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with IF AND OR 6
Help with SUMIF formula 3
Unexpected result from IF statement... Help with formula. 3
Optimising calculation time 11
Coding Formula 2
INDEX MATCH CONCATENATE 1
formula help to change row colour automatically by some conditions 6
Formula Help 2

Back
Top