Formula Question

Q

Qaspec

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.
 
W

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

[email protected]

| 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.
|
 
Top