Hi Folks,
I am trying to create a staggered pricing model in excel and need a little leg up.
I want to enter the quantity into one cell and have a formula pull the price from a two-column table like below and return the price into a "total' cell. Seems easy enough, though I can't figure out how to make it differentiate the quantities and prices. Any help would be appreciated.
0-5000 $1.00
5000-6000 $0.90
6000-7000 $0.80
7000-8000 $0.70
8000-9000 $0.60
9000-10,000 $0.50
10,000-50,000 $0.40
50,000-100,000 $0.30
100,000-1,000,000 $0.20
1,000,000+ $0.10
Bookmarks