PDA

View Full Version : [SOLVED] How do I combine two statements in Excel?



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.

spittingfire
05-02-2015, 01:48 PM
I was able to find a workable solution

=IF(I1="burnaby",IF(AND(T1="shift",U1>=210),"shot20","shot10"),IF(AND(T1="shiftfp",U1<480),"shot10","shot15"))