Help with IF statement

I am trying to do a spreadsheet that looks at a specific cell to see if it says "Service" in column U, then look at column AW to see if it is greater than 3000, if it is return shop and if it isn't return field. If the text in column U does not = "Service" then it should automatically become the text in column U. All my formulas will be in Column S.

Thank you!

Try

=IF(U2="Service",IF(AW2>3000,"Shop","Field"),U2)

Thank you! Solved.

You're welcome.