Forum Discussion

Plrooff's avatar
Plrooff
Copper Contributor
May 20, 2024

Create formula by combining two formulas

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 ...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
May 20, 2024

Plrooff 

 

IF(OR(AND(Bank="DSB", Month<7), AND(Bank="CCB", Month<13)), IntroRate, Prime)

  • Plrooff's avatar
    Plrooff
    Copper Contributor
    May 21, 2024
    Hans,
    Thank you. I probably didn't make myself clear.
    What I am trying to say with the combined formula is:
    If Bank is "DSB" and Month is less than 7, OR if Bank is "CCB" and Month is less than 13, I
    want IntroRate, otherwise I want Prime.
    Thanks for any suggestions.
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 21, 2024

      Plrooff 

      Is this better?

       

      IF((Bank="DSB")*(Month<7)+(Bank="CCB")*(Month<13), IntroRate, Prime)

Resources