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.

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.

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.