| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested IF - too many arguements.
System error of to many arguements, Need help please.
I tried nested IF but can't get everything in.... In E need formula that reads B 'group' returning "FLAG" if values of C 'Long' and/or D 'Short' are greater then limits established in reference chart, if less than reference chart return blank. A B C D E 1 Unit# group Long Short results 2 3119 APU 3.20% 0.20% FLAG 3 1655 TEAM 10.00% 4.00% 4 3234 TEAM 16.00% 5.00% FLAG 5 101001 SOLO 10.00% 0.00% 6 101112 SOLO 22.00% 0.00% FLAG 7 1035 LOCAL 21.00% 4.40% FLAG 8 1034 LOCAL 10.00% 5.40% reference chart located on 'info' sheet.. (values below are input weekly) A B C 1 Long Short 2 LOCAL 20% 10% 3 SOLO 18% 8% 4 TEAM 15% 5% 5 APU 2% 1% This was the formula I =IF(B2="TEAM",IF(OR(C2info!$B$4,D2info!$C$4),"FL AG"),IF(B2="SOLO",IF(OR(C2info!$B$3,D2info!$C$4) ,"FLAG",""),""),"") Thank you in advance with your help! -- Tacoma-WA EOD- we take the licking when it stops ticking. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested IF - too many arguements.
In E2:
=IF(SUMPRODUCT((info!$A$2:$A$5=B2)*(info!$B$2:$B$5 =C2)*(info!$C$2:$C$5=D2)),"","FLAG") copy down as far as needed "Dave" wrote: System error of to many arguements, Need help please. I tried nested IF but can't get everything in.... In E need formula that reads B 'group' returning "FLAG" if values of C 'Long' and/or D 'Short' are greater then limits established in reference chart, if less than reference chart return blank. A B C D E 1 Unit# group Long Short results 2 3119 APU 3.20% 0.20% FLAG 3 1655 TEAM 10.00% 4.00% 4 3234 TEAM 16.00% 5.00% FLAG 5 101001 SOLO 10.00% 0.00% 6 101112 SOLO 22.00% 0.00% FLAG 7 1035 LOCAL 21.00% 4.40% FLAG 8 1034 LOCAL 10.00% 5.40% reference chart located on 'info' sheet.. (values below are input weekly) A B C 1 Long Short 2 LOCAL 20% 10% 3 SOLO 18% 8% 4 TEAM 15% 5% 5 APU 2% 1% This was the formula I =IF(B2="TEAM",IF(OR(C2info!$B$4,D2info!$C$4),"FL AG"),IF(B2="SOLO",IF(OR(C2info!$B$3,D2info!$C$4) ,"FLAG",""),""),"") Thank you in advance with your help! -- Tacoma-WA EOD- we take the licking when it stops ticking. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested IF - too many arguements.
You can put this formual in E2 and copy down as far as necessary
=IF(OR(C2VLOOKUP(B2,Info!$A$2:$C$5,2,FALSE),D2VL OOKUP(B2,Info!$A$2:$C$5,3,FALSE)),"FLAG","") Tyro "Dave" wrote in message ... System error of to many arguements, Need help please. I tried nested IF but can't get everything in.... In E need formula that reads B 'group' returning "FLAG" if values of C 'Long' and/or D 'Short' are greater then limits established in reference chart, if less than reference chart return blank. A B C D E 1 Unit# group Long Short results 2 3119 APU 3.20% 0.20% FLAG 3 1655 TEAM 10.00% 4.00% 4 3234 TEAM 16.00% 5.00% FLAG 5 101001 SOLO 10.00% 0.00% 6 101112 SOLO 22.00% 0.00% FLAG 7 1035 LOCAL 21.00% 4.40% FLAG 8 1034 LOCAL 10.00% 5.40% reference chart located on 'info' sheet.. (values below are input weekly) A B C 1 Long Short 2 LOCAL 20% 10% 3 SOLO 18% 8% 4 TEAM 15% 5% 5 APU 2% 1% This was the formula I =IF(B2="TEAM",IF(OR(C2info!$B$4,D2info!$C$4),"FL AG"),IF(B2="SOLO",IF(OR(C2info!$B$3,D2info!$C$4) ,"FLAG",""),""),"") Thank you in advance with your help! -- Tacoma-WA EOD- we take the licking when it stops ticking. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i have more than 30 arguements in a SUM | Excel Discussion (Misc queries) | |||
| OR Function with more than 30 arguements | Excel Discussion (Misc queries) | |||
| Too many arguements | Excel Discussion (Misc queries) | |||
| Formula using IF, AND and OR Arguements | Excel Worksheet Functions | |||
| NPV calc with more than 29 arguements? | Excel Worksheet Functions | |||
Hybrid Mode
