Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
What is the formula for below equation?
Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
Rechie wrote:
What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie From the ground-up I would think it's Net=Qty*UnitPrice*(1-Discount)*(1+Freight) I'm too lazy to see if your formula simplifies to the same. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
=2*100*(2-5%*(1+2%)) = 389.8
=2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) = 389.8 Regards, Stefi €˛Rechie€¯ ezt Ć*rta: What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
Hi Stefi,
Thanks, but if I will compute it manually the results is different: 2*100 =200 Discount 5% = 10 (less) Freight Chrgs 2% = 4 (add) --------- Net Amount = 194 "Stefi" wrote: =2*100*(2-5%*(1+2%)) = 389.8 =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) = 389.8 Regards, Stefi €˛Rechie€¯ ezt Ć*rta: What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
On Thu, 15 Oct 2009 08:54:14 -0700, Rechie
wrote: What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie =Qty*Unit_Price*(1-Discount+Freight) or, in your terms =2*100*(1-5%+2%) --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
It's working, Thanks!
"smartin" wrote: Rechie wrote: What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie From the ground-up I would think it's Net=Qty*UnitPrice*(1-Discount)*(1+Freight) I'm too lazy to see if your formula simplifies to the same. . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
It's working, thanks!
"Ron Rosenfeld" wrote: On Thu, 15 Oct 2009 08:54:14 -0700, Rechie wrote: What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie =Qty*Unit_Price*(1-Discount+Freight) or, in your terms =2*100*(1-5%+2%) --ron . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
It's interesting that you say "It's working, thanks!" in response to this
formula, but also in response to the alternative suggestion, which is effectively =2*100*(1-5%)*(1+2%) They give different answers, so you'll have to decide which you want, but the latter would be more usual. Your formula, of course, gave a totally different answer, of the order of twice the correct answer, so congratulations if you can persuade your customers to pay that much. :-) -- David Biddulph "Rechie" wrote in message ... It's working, thanks! "Ron Rosenfeld" wrote: On Thu, 15 Oct 2009 08:54:14 -0700, Rechie wrote: What is the formula for below equation? Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie =Qty*Unit_Price*(1-Discount+Freight) or, in your terms =2*100*(1-5%+2%) --ron . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Direct to sheet | Excel Discussion (Misc queries) | |||
Can you direct me. | Excel Discussion (Misc queries) | |||
MS Query Direct Invoking? | Excel Discussion (Misc queries) | |||
Direct reference | Excel Worksheet Functions | |||
Emailing XML direct from Excel | Excel Discussion (Misc queries) |