IF function help!!

[Sean1990]

Hi,

I would massively appreciate some help in solving a if function formula.

I'll try and explain below:

1. If G5 is equal to 75 or below 75 this is "Inadequate".

2. If G5 is equal to 76, equal to 89 or between 76 and 89 this is "Requires Improvement"

3. If G5 is equal to 90, equal to 94 or between 90 and 94 this is " Good"

4. If G5 is equal to 95 or above this is "Outstanding"

If the 4 points above could be put into some sort of super formula that would be excellent. I'm also happy to use a different type of formula if it would be more suited.

Thanks in advance.

[Bob Phillips]

Try

=VLOOKUP(G5,{75,"Inadequate";76,"Requires Improvement";90,"Good";95,"Outstanding"},2,TRUE)

You could put the lookup values in a table and refer to that.

[AlKey]

Or

=LOOKUP(G5,{0,75,89,94,95},{"Inadequate","Requires Improvement","Good","Outstanding"})

[Richard Buttrey]

Hi,

One way

=IF(G5<=75,"Inadequate",IF(AND(G5>75,G5<=89),"Requires Improvement",IF(AND(G5>89,G5<=94),"Good","Outstanding")))

[rcm]

see the file. A grade table was created to enable changes

[Glenn Kennedy]

In a VLOOKUP table....

[Sean1990]

In a VLOOKUP table....

This worked perfectly! Thank you.

Thanks for all the responses. My job becomes a lot easier now.