ExcelBanter - Deducting a %

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Deducting a % (https://www.excelbanter.com/excel-worksheet-functions/81050-deducting-%25.html)

Wizard

Deducting a %

Hi I am trying to work out a formula for deducting the a certain percentage
of an amount ie:

£204.44 - 11% = £181.95

A1 A2
204.44 181.95

Thanks

Wiz (but not so in this case)

Sean

Deducting a %

Hi,

Try place the following formula in A2

=A1-A1*0.11

Sean

"Wizard" wrote in message
. uk...
Hi I am trying to work out a formula for deducting the a certain
percentage of an amount ie:

£204.44 - 11% = £181.95

A1 A2
204.44 181.95

Thanks

Wiz (but not so in this case)

Niek Otten

Deducting a %

In A2:
=A1*(1-11%)

--
Kind regards,

Niek Otten

"Wizard" wrote in message . uk...
Hi I am trying to work out a formula for deducting the a certain percentage of an amount ie:

£204.44 - 11% = £181.95

A1 A2
204.44 181.95

Thanks

Wiz (but not so in this case)

All times are GMT +1. The time now is 09:59 PM.