Calculate price based on quantity

Hi everyone,

I`m relatively inexperienced with Excel, searched for a few days and have not been able to figure out how to calcuate this value.

I have multiple worksheets to work out financials. I have a separate worksheet with the pricing breakdown based on volume. 2 columns
0 - 99,999 0.05
100,000 - 499,999 0.04
500,000 - 999,999 0.03
1,000,000+ 0.03

On a separate worksheet I want to add I6+I7, depending on the value multiply it by the value in the second column. So if the total is 520,000 then multiply it by 0.03.

I would really appreciate any help.

Thanks!

In the first column only list the bottoms of the ranges..

e.g

0
100000
500000
1000000

Then multiply by:

Lookup(A1,Sheet2!$A$1:$B$4)

where A1 is your lookup value and table is in Sheet2!A1:B4

Would you kindly mark your thread as Solved.?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You can change your table to:

Please Login or Register  to view this content.