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
|