Formula Question

[Guest]

I'd like to enter a formula where if c1 is greater than 1 then c18 equals A
if c1 is between 90-100 then
c18 equals B
if c1 is between 80-89 then
c18 equals C
if c1 is less than 80 then
c18 equals D

Thanks for any help.

 

[William]

Hi

Your example is ambiguous so I have amended the conditions to
if c1 is between 1 and 69 then A
if c1 is between 70 and 79 then D
if c1 is between 80 and 89 then C
if c1 is between 90 and 100 then B

Given the above, try the formula in C18 of the following (all one line if
text wraps)

=IF(C1>100,"Greater
than100",IF(C1>=90,"B",IF(C1>=80,"C",IF(C1>=70,"D",IF(C1>=1,"A","Invalid")))
))

--
XL2002
Regards

William

(e-mail address removed)

| I'd like to enter a formula where if c1 is greater than 1 then c18 equals
A
| if c1 is between 90-100
then
| c18 equals B
| if c1 is between 80-89 then
| c18 equals C
| if c1 is less than 80 then
| c18 equals D
|
| Thanks for any help.
|

 

[Jason Morin]

=IF(C18=1,"A",LOOKUP(C18,{2,80,90},{"D","C","B"}))

HTH
Jason
Atlanta, GA