New Contributor

Combine Multiple IF Formulas

I have the following formulas that I need to combine and the results in the same column/cell.

=IF(AND(N2>7.6,I2>40),"40",IF(I2<40,I2))

And

=IF(AND(N5=7.5,I5>37.5),"37.5",IF(I5<37.5,I5))

Both formulas work fine separately, but I need them to be in one cell, i.e. combined. How do I accomplish this?

4 Replies

Re: Combine Multiple IF Formulas

It very depends on which logic you'd like to use combining conditions. As variant

``````=IF(AND(N2>7.6,I2>40),   40,
IF(I2<40,               I2,
IF(AND(N5=7.5,I5>37.5), 37.5,
IF(I5<37.5,             I5,
"nothing"
))))``````

Re: Combine Multiple IF Formulas

Thanks this seems to be working except the  IF(AND(N5=,I5>37.5), 37.5 is not returning 37.5 in the cell if I5>37.5. Am I doing something wrong?

` `

Re: Combine Multiple IF Formulas

Perhaps since I2<40, when formula returns I2. Formula can't return both I2 and result of next condition, only one of them. We may only change priority, first check N5 & I5, next I2. But I don't know which logic you assume.

Re: Combine Multiple IF Formulas

@Sergei Baklan I was able to get it to work...Thanks so much for your assistance.