IF funtion question
None of the answers so far appear to me to be correct. I believe the OP
meant that the cost increments like this:
1-5 10.00
6-10 15.00
11-15 20.00
16-20 25.00
21-25 30.00
If so, and taking into account that zero items should probably not cost
$10,00, the formula might look like this:
=IF(A10,5+INT((A1+4)/5)*5,0)
dribler2 wrote:
no of items on A1.
=IF(A110,15+(A1-10)/2,IF(A1=5,10+(A1-5),IF(A1<5,A1*2,"X")))
20 items = 20.00
15 items=17.50
10 items = 15.00
5 items = 10.00
maybe this is formulated for reduced selling price as qty of item increase.
"wm" wrote:
Hi all,
Kindly assist on the following:
eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items
Thus, if the total is 20 items, then the answer would be 20.00
Pls adv on generating the formula for the above. Thanks in advance.
wm..
--
Gary L. Smith
Columbus, Ohio
|