Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to discount percentage
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to discount percentage
Pl try following formula
=a1*(1-b1) ================================================== "David Wilson" 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to discount percentage
I hope that you meant to say not =a1*(1-b1) but =a1*(1+b1) ?
-- David Biddulph "HARSHAWARDHAN. S .SHASTRI" wrote in message ... Pl try following formula =a1*(1-b1) ================================================== "David Wilson" 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to discount percentage
If you mean by -37% a discount of 37% it would be easier to call column B
Discount and enter 37% and use the formula =A1*(1-B1) It would save you having to key a minus sign infront of every discount percent And technically we don't talk about a negative discount, just a discount. -- If this helps, please click the Yes button Cheers, Shane Devenshire "David Wilson" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Either percentage or dollar discount formula | Excel Worksheet Functions | |||
How do I use a formula in excel to get a percentage discount | Excel Discussion (Misc queries) | |||
Percentage Discount | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) |