If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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 
Ads 
#2




A formula to discount percentage
Pl try following formula
=a1*(1b1) ================================================== "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




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




A formula to discount percentage
I hope that you meant to say not =a1*(1b1) but =a1*(1+b1) ?
 David Biddulph "HARSHAWARDHAN. S .SHASTRI" > wrote in message ... > Pl try following formula > > =a1*(1b1) > > ================================================== > > "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




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*(1B1) 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 > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Either percentage or dollar discount formula  KHiggins2008  Excel Worksheet Functions  2  June 12th 08 03:08 PM 
How do I use a formula in excel to get a percentage discount  birch  Excel Discussion (Misc queries)  1  September 21st 06 02:22 AM 
Percentage Discount  Ruth  Excel Discussion (Misc queries)  3  July 20th 06 02:35 PM 
Percentage Discount Total  mdj101  Excel Discussion (Misc queries)  1  May 18th 06 04:33 PM 
Percentage Discount Total  mdj101  Excel Discussion (Misc queries)  2  May 18th 06 04:20 PM 