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..