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 make...
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