Thread: Deducting a %
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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)