Nested if statement between values

[dpbarry]

Hi Folks..

Would appreciate a bit of assistance on a nested if statement. My boss has asked if it is possible to format a cell based on the contents of another cell.

What he means is, if we have the following grouping:

83-99 'Underachieving'
100-110 'Average'
111-126 'Above Average'

and say cell A1 has the value 92, cell B2 would say 'Underachieving'. Similarily, if cell A1 had the value 120, Cell B2 would say 'Above Average'
How do I format the nested if statement in Cell B2 to display the relevant value.

Assistance greatly appreciated.

Declan

 

[Joe4]

Wondering if someone could help with a similar problem?

Please post your problem to its own thread instead of posting to a really old thread.
The people on this thread have not been active here in years!