Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another difficult failed formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |