Excel 2007 : Relatively complex IF functions

Hi All,

I have attached the workbook im working on.

Basically, I have a table with a reverse bidding system. I have a min & max set of buyers for each price point.

What I want to do is (refer to the formula in D7, is have it so, if "x" (cell A9) is 12, it will be A9*C4. And if cell A9=22, then it will be A9*C5.

What I keep getting is the dynamic part (the sale price) wont change as the number increases...

Any help is much appreciated!

cheers,

chaosreign21

test.xlsx

Hello
If you're trying to find the price of the value in A9 which lies equal to and between the Min and Max values then try the following:

=VLOOKUP(A9,$A$3:$C$6,3,TRUE)*A9

Hope this is what you want.