How to add multiple IF statements to WORKDAY function?

Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have

=WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49)


I want to add 2 more cities. The function can either be from another column/sheet that has the cities to pull from or multiple IF statements.

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!