How do I combine two statements in Excel?

[spittingfire]

I have the below two excel formulas that I am trying to combine into one statement.

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

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.

[FDibbins]

Give this a shot, let me know how it goes...
=IF(T1="shift",IF(AND(U1>=201,I1="Burnaby"),"shot20",""),IF(AND(T1="shifttp",U1<480),"shot10","shot15"))

[spittingfire]

Thanks for you assistance FDibbins but it doesn't produce the expected results.

The results I got when I changed U1 to 200 and I1 has Burnaby and T1 has SHIFT the results were just a blank cell when I was expecting a SHOT10 results.

What I am looking to accomplish is if Column I has Burnaby then the first condition should be check and the results can only be SHOT20 or SHOT10 and nothing else. If Burnaby is not present then the results can only be SHOT10 or SHOT15.

Is something like this possible?

Thanks again for your help

[FDibbins]

I thought I had a few things mixed around...
=IF(I1="burnaby",IF(AND(T1="shift",U1>=210),"shot20","shot10"),IF(AND(T1="shiftfp",U1<480),"shot10","shot15"))

[spittingfire]

Thanks FDibbins,

That seems to have done the trick - thanks again for the help.

[FDibbins]

Great Thanks for the feedback