Desperately need help with tiered pricing

[prolinklogistics]

I'm trying to get the tiered tariffs of vendors into a sheet that can also work as a calculator.

The data is very simple but unfortunately i'm bad at excel.

0-1 container : IDR 750,000
2 container onwards: IDR 300,000

Appreciate if anyone can help me solve this. Thanks.

<quote>

</quote>

 

[prolinklogistics]

Anyone?

 

[kvsrinivasamurthy]

IN F6 use, then drag down
=INDEX($B$15:$B$16,MATCH(E6,$A$15:$A$16))

 

[prolinklogistics]

Thank you for your help, but it didn't work as you can see in below image.

0-1 : IDR 750,000
2-onwards: IDR 300,000

2 Containers should be: IDR 1,050,000

 

[prolinklogistics]

ADVERTISEMENT

ANYONE PLEASE...im at office now with unfinished report.

 

[prolinklogistics]

Test

 

[kvsrinivasamurthy]

For E6=2 F6 You are getting 300000.
Give list of For what values of E what should be F.