Discussion Re: Combine Multiple IF Formulas in Excel
https://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566367#M107461
<P><LI-USER uid="1087504"></LI-USER> </P>
<P>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.</P>Tue, 20 Jul 2021 15:20:40 GMTSergei Baklan2021-07-20T15:20:40ZCombine Multiple IF Formulas
https://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2483481#M104547
<P>I have the following formulas that I need to combine and the results in the same column/cell.</P><P> </P><P>=IF(AND(N2>7.6,I2>40),"40",IF(I2<40,I2))</P><P>And</P><P>=IF(AND(N5=7.5,I5>37.5),"37.5",IF(I5<37.5,I5))</P><P> </P><P>Both formulas work fine separately, but I need them to be in one cell, i.e. combined. How do I accomplish this?</P>Thu, 24 Jun 2021 21:07:22 GMThttps://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2483481#M104547Denise_Heil2021-06-24T21:07:22ZRe: Combine Multiple IF Formulas
https://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2485399#M104615
<P><LI-USER uid="1087504"></LI-USER> </P>
<P>It very depends on which logic you'd like to use combining conditions. As variant</P>
<LI-CODE lang="excel">=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"
))))</LI-CODE>Fri, 25 Jun 2021 13:35:54 GMThttps://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2485399#M104615Sergei Baklan2021-06-25T13:35:54ZRe: Combine Multiple IF Formulas
https://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566178#M107449
<P><LI-USER uid="521"></LI-USER> </P><P>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?</P><PRE> </PRE><P> </P>Tue, 20 Jul 2021 14:41:28 GMThttps://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566178#M107449Denise_Heil2021-07-20T14:41:28ZRe: Combine Multiple IF Formulas
https://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566367#M107461
<P><LI-USER uid="1087504"></LI-USER> </P>
<P>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.</P>Tue, 20 Jul 2021 15:20:40 GMThttps://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566367#M107461Sergei Baklan2021-07-20T15:20:40ZRe: Combine Multiple IF Formulas
https://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566472#M107466
<P><LI-USER uid="521"></LI-USER> I was able to get it to work...Thanks so much for your assistance.</P>Tue, 20 Jul 2021 15:48:36 GMThttps://techcommunity.microsoft.com/t5/excel/combine-multiple-if-formulas/m-p/2566472#M107466Denise_Heil2021-07-20T15:48:36Z