Forum Discussion
Solved
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 "Com...
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
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!
