Margaret

=LOOKUP(A1,{0,40,50,60,70,80,90,100},{"E","D","C-","C","C+","B","B+","A"})

Adjust ranges and letter scores as required.


Gord Dibben Excel MVP

On Sat, 5 Feb 2005 06:59:02 -0800, "Margaret"
<Margaret@discussions.microsoft.com> wrote:

>Thank you, Julie.
>Can I write a series of inequalities? I am a teacher and I want the grade
>to be posted in the column. So if my grade boundaries are the followin:
>95-100 is an A+, 90-95 is an A... and so on for the rest of my grades
>Thanks,
>Margaret
>
>"JulieD" wrote:
>
>> Hi Margaret
>>
>> =IF(AND(A1>20,A1<40),5,0)
>>
>> where x = A1
>>
>> Cheers
>> JulieD
>>
>> "Margaret" <Margaret@discussions.microsoft.com> wrote in message
>> news:B325C744-89AE-4929-AA2A-8CCDEBDF9D3C@microsoft.com...
>> > How do I write an inequality in excel? For example, if 20<x<40 then write
>> > 5
>> > in the
>>
>>
>>