Nested IFs

Giganews Newsgroups
Subject: Nested IFs
Posted by:  Dig (lwn…@quixnet.net)
Date: Thu, 16 Oct 2003

I have Excel 2K and am trying to creat a nested IF statement that
would change a number grade to a letter grade.

      In other words if the student received a 70 as the grade I want a
formula to convert that to a C. I was thinking that nested IFs are the way
so that the same formula will work for all grades A,B, C, D, F.

      So it needs to check the cell to the left for the numeric grade and
then convert.
      The grades are from
      <60  =F
      60-69 =D
      70-79 =C
      80-89 =B
      90-100 =A

      Any help would be apprecitated.
      Thanks

Replies