| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deducting a monthly payment | New Users to Excel | |||
| deducting the same percent in a column | Excel Worksheet Functions | |||
| Deducting breaks from time measurements | Excel Worksheet Functions | |||
Linear Mode
