Forum Discussion

BBFDSue's avatar
BBFDSue
Copper Contributor
Feb 19, 2020
Solved

Nesting IF Function in Excel

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 w...
Formulas and Functions
  • Jennifer Lefief's avatar
    Jennifer Lefief
    Feb 19, 2020
    =IF(C8="Prince George",2300,(IF(OR(D8="James",D8="Princeton"),650,900)))
Jennifer Lefief's avatar
Jennifer Lefief
Copper Contributor
Feb 19, 2020
=IF(C8="Prince George",2300,(IF(OR(D8="James",D8="Princeton"),650,900)))
  • Jennifer Lefief's avatar
    Jennifer Lefief
    Copper Contributor
    Feb 19, 2020

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

    • BBFDSue's avatar
      BBFDSue
      Copper Contributor
      Feb 19, 2020
      Thank you!! I figured it out with the "james" in there! It works beautifully. Thank you again!

Resources