Formula Question:c1 is greater than 1

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

[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

willwest22@yahoo.com

"Qaspec" <Qaspec@discussions.microsoft.com> wrote in message
news:8E05F002-E65A-418C-B510-0230A40709C5@microsoft.com...
| 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

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