IF then statements-Tiered PRicing
=IF(X<100,10,IF(X=100,8,5))
"Jackiec21" wrote:
Thank you for your quick response. If X=100, then price is $8.00, so how do
I need to enter that one??
"Dave F" wrote:
=IF(X<100,10,IF(X100,5))
You don't specify what happens if X = 100.
Dave
--
Brevity is the soul of wit.
"Jackiec21" wrote:
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!
|