Nesting IF Function in Excel

[BBFDSue]

I need a little help! I have this formula and it works great! But I need to add another option to it. 

=IF(C8="Prince George",2300,(IF(D8="Princeton",650,900)))

Currently, as you can see if we ship from Prince George it's $2300. If we ship from anywhere else to Princeton it's 650. If it's none of the above it's $900. 

I need to add another location to the SAME price rate as Princeton. So simply said, I'd like the formula to "say", Princeton OR West Kelowna the price is $650. 

Do I have to add a third entire If Function or is there a way to say "or" for the Princeton rate within these two nested functions. (When I try to add a third function it goes wonky on me)

[#2 · Accepted solution]

=IF(C8="Prince George",2300,(IF(OR(D8="James",D8="Princeton"),650,900)))

[#3]

ha - I didnt even read the 2nd half your question - replace "James" my made up name with "West Kaloma".

[#4]

Thank you!! I figured it out with the "james" in there! It works beautifully. Thank you again!