I have two similar IF formulas which are populating two columns.  They are mutually exclusive.  Both give the results I want.  I want to combine these formulas so the results of the one that is TRUE populates the column.  I can’t get this to work.  I think it may only be a case of structuring or punctuation.  I am trying to use the OR function nested in an IF.

My formulas look like this, where Bank, Month, IntroRate, and Prime are defined for use in formulas:

       IF(Bank=”DSB”,IF(Month<7),IntroRate,Prime)

       IF(Bank=”CCB”,IF(Month<13),IntroRate,Prime)

Thank you for any suggestions.

​I have two similar IF formulas which are populating two columns.  They are mutually exclusive.  Both give the results I want.  I want to combine these formulas so the results of the one that is TRUE populates the column.  I can’t get this to work.  I think it may only be a case of structuring or punctuation.  I am trying to use the OR function nested in an IF. My formulas look like this, where Bank, Month, IntroRate, and Prime are defined for use in formulas:       IF(Bank=”DSB”,IF(Month<7),IntroRate,Prime)       IF(Bank=”CCB”,IF(Month<13),IntroRate,Prime) Thank you for any suggestions.          Read More

​