View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default A formula to discount percentage


=A1*(1+B1)


On Feb 12, 11:01*pm, David Wilson <David
wrote:
I am trying to find a formula to discount by percentage rather than currency
on Excel 2007.

Example:

* *A1 * * * * * * B1 * * * * * * * C1
* £25 * * * * *-37% * * * = £15.75
* £33 * * * * *-23% * * * = £25.41