Forum Discussion
Solved
Subtract a percentage of a cell in the if Formula
I have a cell that is adding other cells to it under IF conditions, I would the like to be able to minus a percentage off of the total of that cell showing the total in the cell itself.
If that makes any sense.
MichaelMannPhotography Whatever formula you have now, you can extend it with a multiplication of (1 minus %).
Something like this if you would want to deduct 10%:
= <your formula> * (1 - 10%)
Replace the 10% part with a cell reference if you have the percentage in another cell.
MichaelMannPhotography Whatever formula you have now, you can extend it with a multiplication of (1 minus %).
Something like this if you would want to deduct 10%:
= <your formula> * (1 - 10%)
Replace the 10% part with a cell reference if you have the percentage in another cell.
- Thanks mate, this worked a treat
- Thanks for the reply.
So I would like to have.
My collection amount, and then the amount goes up IF there are ad ons, for the moment I have that part working. But I would like to be able to apply a 10% discount to the total of the colelction with all the add ons, and then that total shows in the collection amount, without needting to add another column.
Here is the formaula I have so far with all the IF formulas working with the add ons.
=(((IF(H5=$D$153,$D$154,0)+IF(H5=$E$153,$E$154,0)+IF(H5=$F$153,$F$154,0)+IF(H5=$G$153,$G$154,0)+IF(H5=$H$153,$H$154,0)+IF(H5=$I$153,$I$154,0)+IF(H5=$J$153,$J$154,0)+IF(H5=$K$153,$K$154,0)+IF(H5=$L$153,$L$154,0))+(IF(I5=$C$126,500,0))+(IF(J5=$C$162,800,0))))
I would like to be able to then have something like IF(K5=10%, then minus 10% off of the total of M5 (which is the colelction total with the if add ons above.=(XLOOKUP(H5,$D$153:$L$153,$D$154:$L$154,0)+500*(I5=126500)+800*(J5=162800))*(1-K5)
