IF Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to correlate a sum w/ a letter value such as the following:


IF:SUM(a1:a8< 3) = D. IF:SUM(a1:a8< 5 > 3) = C. IF:SUM(a1:a8< 7 > 5) = B.

I need this all in one formula.

Any help?
 
Hi

=IF(A1<3,"D",IF(A1<5,"C","B"))
then copy down this formula for all 8 rows

One remark
in the above formula the sum 3 will receive the letter "C" and the sum
5 the lette "B". If you want to change this, change the expressions
accordingly

Frank
 
use this

=IF(SUM(A1:A8)<3,"d",IF(SUM(A1:A8)<5,"c",IF(SUM(A1:A8)<7,"b")))

if the sum of a1-a8 is greater then or equal to 7 it is going to
display false. if you want it to display a different letter just add
one more condition like this

=IF(SUM(A1:A8)<3,"D",IF(SUM(A1:A8)<5,"C",IF(SUM(A1:A8)<7,"B","A")))

Randall
 
Back
Top