IF then statements-Tiered PRicing
Please help!
I am going to have to create an Excel spread using tiered pricing. I
imagine it will be:
IF QUANTITY PRICE
<100 10.00
100 5.00
Please help-I have no idea how to use an "IF" statement to make this work
and this is what my boss wants. Thanks!
|