in columns OP (modifiers) I need when the percentage to calculate 100% whenever is data is entered in column "O" but nothing in column "P". it's working just fine when something is entered into column "O" and column "P". but again if nothing is entered into "O" but entered into "P" it does not return a zero and it should...HELP!!! please
I've highlighted in yellow where it should calculate and green is the column to be calculated
This is driving me bunkers and I swear it's going to be some simple fix I simply cannot figure out 🙁
Hi Tiffany,
You're calculating a percentage by dividing three numbers
=IFERROR(1-((SUMIF($D$18:$D$67,E$1,$P$18:$P$67))/(SUMIF($D$18:$D$67,E$1,$O$18:$O$67)))/((SUMIF($D$18:$D$67,E$1,$P$18:$P$67))),"%")
and then subtracting the result from 1. I'd just divide one by the other and set the cell format to Percentage. And change the IFERROR to return 0 on a divide by zero
Try this
=IFERROR(((SUMIF($D$18:$D$67,E$1,$P$18:$P$67))/(SUMIF($D$18:$D$67,E$1,$O$18:$O$67))),0)
See modified file - attached.
Regards
Phil
