i guss ur eq is wrong. according to ur logic if the total is 20 items, then
the answer would be 25.00

however see the below mentioned foumula
=IF(A1=5,10+INT((A1-5)/5)*5,10)

or

=IF(A1=5,10+((A1-5)/5)*5,10)

u can try both formula

if u need further information, pls let me know

pls do rating




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