I am trying to figure out how to "code" this problem using a formula
I have 1 input value in A1 ex 333,000
Want to check it against this matrix
Columng A
<TBODY>
</TBODY>
Think of it as a volume discount/penalty applied to the unit price if the volume is above or below certain volume points. I want to be able to change the comparison sign in different cases
I tried IF(a1&a3&b3,c3,"") and it does not evaluate...
Thanks for looking into this
Theo
I have 1 input value in A1 ex 333,000
Want to check it against this matrix
Columng A
Column A | Column B | Column C |
<= | 200,000 | +10% |
<= | 300,000 | +5% |
>= | 400,000 | -5% |
>= | 600,000 | -10% |
<TBODY>
</TBODY>
Think of it as a volume discount/penalty applied to the unit price if the volume is above or below certain volume points. I want to be able to change the comparison sign in different cases
I tried IF(a1&a3&b3,c3,"") and it does not evaluate...
Thanks for looking into this
Theo