Hello everyone.

This is my first post here. I've attempted to find the answer in previous

posts but can. Any help would be really appreciated.

I have 5 colums of results:

AZ2

BA2

BB2

BC2

BD2

I have 6 possible grades:

For 100-92..."Level 6"

For 91 - 79..."Level 5"

For 78 - 70..."Level 4"

For 69 - 50..."Level 3"

For 49 - 34..."Level 2"

Below 34......."Level1"

I need the output to be a Level based on the lowest result from each column.

I thought I could use the IF & OR function for this, but as far as I know it

works for only 2 types of results. Any help on what I could use to expand

this to include all the levels mentioned above?

:

This works...but just for 2 possible results!

=IF(OR(AZ2<=69,BA2<=69,BB2<=69,BD2<=69),"Level 3","Level 4")

Thanks in advance,

Phil

## Bookmarks