May 20 2024 01:15 PM
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.
May 20 2024 01:29 PM
May 20 2024 06:56 PM
May 21 2024 12:18 AM