Forum Discussion
Nested IF function with Sums, and Greater Than
Hi Everyone,
I am trying to have an IF formula work with multiple criteria and I keep getting Zero Value. I am trying to put the formula in column "P" Total "A"/"B" Commission
Essentially if "Combined Rate" is "Yes" I would like the formula to do ('Company "A" Commission' + 'Company B Commission') if that amount is greater than "Minimum" if amount is not greater than "Minimum" I want the "Minimum". If "Combined Rate" is "No" I would like the formula to do "Total Company "A"' + "Total Company "B"" this is the formula I have right now that isn't bringing in "0" values.
=SUM(IF(Q2="Yes",IF(H2+M2>I2,H2+M2,I2),J2+O2))
Thank you!
Hi Mary,
Formula shall work if all your cells are in number format. Strange that zeroes in some columns are on left side of the cells, that usually means the cells are in text format. Anyway, without the sample it's hard to say.
And in your formula SUM is not required,
=IF(Q2="Yes",IF(H2+M2>I2,H2+M2,I2),J2+O2)
is enough
2 Replies
Hi Mary,
Formula shall work if all your cells are in number format. Strange that zeroes in some columns are on left side of the cells, that usually means the cells are in text format. Anyway, without the sample it's hard to say.
And in your formula SUM is not required,
=IF(Q2="Yes",IF(H2+M2>I2,H2+M2,I2),J2+O2)
is enough
Thank you!
