Try following:On 2002-08-28 04:13, walkera wrote:
I need to write a formula to minus a percentage of a total.
for example I want to take away 20% of the total of £8.75.
A1: 8.75
A2: 20%
A3: =A1*(1-A2)
Kind regards,
Dennis
This is a discussion on Minus a percentage in a formula within the Excel Questions forums, part of the Question Forums category; ...
I need to write a formula to minus a percentage of a total.
for example I want to take away 20% of the total of £8.75.
Try following:On 2002-08-28 04:13, walkera wrote:
I need to write a formula to minus a percentage of a total.
for example I want to take away 20% of the total of £8.75.
A1: 8.75
A2: 20%
A3: =A1*(1-A2)
Kind regards,
Dennis
Not quite as elegant but you can do it in one cell
a1: £8.75
a2: =((a1/100)*80)
alternativly
if the % deduction changes
a1: Percentage to deduct eg. 20% 30% etc..
a2: Amount eg. £8.75, £9.15 etc
cell b1: = (($a$2/100)*$a$1)
Or if the amount changes
Col C= Amount eg c1 £8.75
Col D = ((c1/100)*$a$1)
You can then drag the formula down column D
For this one keep the format of cell A1 as a number NOT Percentage.
Remember you can use the F4 key to lock the absolute references.
Hope this helps.
DaveA
[ This Message was edited by: applebyd on 2002-08-28 04:50 ]
Even simpler:
A1: £8.75
=A1*(1-20%)
Basic maths!!
Sarcasm not required!
The formula is exactly the same as what would be done on a calculator, though.
Like this thread? Share it with others