Hi!

I'm in need of a formula that allows me to select a product from a drop down list, which displays a unit price (early or late rate) in a separate cell, during either an early or late period, which then allows me to enter a quantity and calculate the costs. Early rate should still remain in place after date has passed, but new data would calculate at the late rate.

i.e. Simplified example
-Product = apples:before $1, after $1.50, oranges: before $2, after $2.50, grapes: before $3, after $3.50
-Date = before June 1 receive the lower rate, after receive the higher rate
-Quantity 0 to any amount = _____

Thanks,
K