That's really clever and elegant!
Stefi
€žPecoflyer€ť ezt Ă*rta:
FROM SA;254822 Wrote:
Is it possible to do the following formal by Microsoft Office Excel
2003:
Products as following
If customer buy 10 parts the cost will be 5$ by parts
If take any number over 10 parts will be 5$ for first 10 and more will
$4
Example if take 12 parts will be the price as following:
(10*5)+(2*4)=58
And this products price as following
0 part to 10 the price 5$
11 to 20 the price 4$
21 to 30 the price 3$
More than 30 the price will be 2$
Example
Customer buys 33 parts so we charge him as following
0 -10 we charge him 10 * 5 $= 50 $
11 €€ś 20 10 * 4 $= 40$
21 -30 10 * 3$ = 30$
31 to 33 3 * 2$ = 6
So the total charge will be 126
please contact me on email:
You can also try
=SUMPRODUCT(--(A1{0;10;20;30});A1-{0;10;20;30};{5;-1;-1;-1})
--
Pecoflyer
Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers
*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71140