Formula Question
 

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.

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(C1100,"Greater
than100",IF(C1=90,"B",IF(C1=80,"C",IF(C1=70,"D" ,IF(C1=1,"A","Invalid")))
))

--
XL2002
Regards

William



"Qaspec" wrote in message
...
| 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.
|

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.

.