What I am trying to do is say-if a customer orders 95 widgits, then the price
is $10.00. If the customer orders 105 widgits (or some other number) than
the price is $5.00. I am still not clear on how to get a price to calculate,
as I received a "False" answer. Thanks for any additional help!

"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!