spittingfire
05-02-2015, 12:16 PM
I have the below two excel formulas that I am trying to combine into one statement.
=IF(U1="","",IF(AND(T1="SHIFT",U1>=210,I1="BURNABY"),"SHOT20","SHOT10"))
=IF(U1="","",IF(AND(T1="SHIFTP",U1<480),"SHOT10","SHOT15"))
When I tried I am getting an error that I am making too many arguments.
I am still relatively new at this and any help would be greatly appreciated.
I tried
=IF(U1="","",IF(AND(T1="SHIFT",U1>=210,I1="BURNABY"),"SHOT20",IF(U1="","",IF(AND(T1="SHIFTP",U1<480),"SHOT10","SHOT15"))))
But the results are not what I am looking for.
Basically the end result of what I am looking for is if Burnaby is present in column I then either return SHOT20 or SHOT10, if not then continue with the rest of the statement.
Thanks again in advance for any assistance you can provide.
=IF(U1="","",IF(AND(T1="SHIFT",U1>=210,I1="BURNABY"),"SHOT20","SHOT10"))
=IF(U1="","",IF(AND(T1="SHIFTP",U1<480),"SHOT10","SHOT15"))
When I tried I am getting an error that I am making too many arguments.
I am still relatively new at this and any help would be greatly appreciated.
I tried
=IF(U1="","",IF(AND(T1="SHIFT",U1>=210,I1="BURNABY"),"SHOT20",IF(U1="","",IF(AND(T1="SHIFTP",U1<480),"SHOT10","SHOT15"))))
But the results are not what I am looking for.
Basically the end result of what I am looking for is if Burnaby is present in column I then either return SHOT20 or SHOT10, if not then continue with the rest of the statement.
Thanks again in advance for any assistance you can provide.