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 |
#2
![]() |
|||
|
|||
![]()
Hi!
Create a table like this somewhere on your sheet: 0 1 34 2 50 3 70 4 79 5 92 6 Assume this table is in the range BF2:BG7. Use this formula to get your result: =VLOOKUP(MIN(AZ2:BD2),BF2:BG7,2,1) If all the cells in the range AZ2:BD2 are empty the formula will return 1. To prevent that: =IF(AND(AZ2="",BA2="",BB2="",BC2="",BD2=""),"",VLO OKUP(MIN (AZ2:BD2),BF2:BG7,2,1)) Biff -----Original Message----- 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 . |
#3
![]() |
|||
|
|||
![]()
Set up a table on your sheet as follows
0 Level 1 34 Level 2 50 Level 3 70 Level 4 79 Level 5 92 Level 6 Name this table RESULTS then use the following formula =VLOOKUP(MIN(AZ2:BD2),RESULTS,2) -- Regards Roger Govier "flyguykorea" wrote in message ... 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 |
#4
![]() |
|||
|
|||
![]()
Thank you both very much for your help...all sorted out now!
Cheers "Roger Govier" wrote: Set up a table on your sheet as follows 0 Level 1 34 Level 2 50 Level 3 70 Level 4 79 Level 5 92 Level 6 Name this table RESULTS then use the following formula =VLOOKUP(MIN(AZ2:BD2),RESULTS,2) -- Regards Roger Govier "flyguykorea" wrote in message ... 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 |
Reply |
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 |