If the requirement of the calculation is as following:

eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

Kindly advise on how to generate a formula for the above. Thanks in advance.

Use If function
Eg
A1: 250 (sample value)
B1: =if(A1<250,50.00,A1*0.20)

pls do rate

"wm" wrote:

If the requirement of the calculation is as following:

eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

Kindly advise on how to generate a formula for the above. Thanks in advance.

Thanks, mate. It helped a lot. :)

"Muhammed Rafeek M" wrote:

Use If function
Eg
A1: 250 (sample value)
B1: =if(A1<250,50.00,A1*0.20)

pls do rate

"wm" wrote:

If the requirement of the calculation is as following:

eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

Kindly advise on how to generate a formula for the above. Thanks in advance.

Dear Muhammed,

Thanks for your help on below.

I have another question for the following case:

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.

Hope u may assist. TQ.



"Muhammed Rafeek M" wrote:

Use If function
Eg
A1: 250 (sample value)
B1: =if(A1<250,50.00,A1*0.20)

pls do rate

"wm" wrote:

If the requirement of the calculation is as following:

eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

Kindly advise on how to generate a formula for the above. Thanks in advance.

wm wrote:
If the requirement of the calculation is as following:
eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

=max(50, 0.20*A1)

Thanks joeu2004. It helped!

" wrote:

wm wrote:
If the requirement of the calculation is as following:
eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

=max(50, 0.20*A1)

I think in ur Q-eq some mistake is the
if item is 20 then answer would be 25 according to ur logic.

pls check it out below mention formula

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

OR

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

u can tray both and see the result.
let me know if u need further information.


"wm" wrote:

Dear Muhammed,

Thanks for your help on below.

I have another question for the following case:

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.

Hope u may assist. TQ.



"Muhammed Rafeek M" wrote:

Use If function
Eg
A1: 250 (sample value)
B1: =if(A1<250,50.00,A1*0.20)

pls do rate

"wm" wrote:

If the requirement of the calculation is as following:

eg: Min 50.00 or 0.20/kg

Since the breakeven point is 250, so if anything is less than 250, then the
charges would be 50.00. However, anything exceed 250 would be based on
0.20*indicated amount. Eg: 0.20*300= 60.00

Kindly advise on how to generate a formula for the above. Thanks in advance.