Hi Kevin

Tua'r Goleuni

Towards the light
Did you by any chance attend Cardiff High School?

--
Regards

Roger Govier


"Kevin James" wrote in message
...
=AND(B6<100,B60)*10+(B6=100)*8+(B6100)*5

--
Kevin James.
Tua'r Goleuni


"Epinn" wrote in message
...
Assume A1 has the number of widgets ordered ......

I like what you said ...... *ordered* is the keyword.

If the user enters a negative number to A1 to indicate the number of
widgets
*returned*, say -200, then the pricing will be off.

Yes, the poster did say "order." I just want to highlight the fact
that there
shouldn't be any negative numbers in A1.

Epinn

"Toppers" wrote in message
...
Assume A1 has the number of widgets ordered, then to calculate price
in (say)
B1:

=IF(A1<100,10,IF(A1=100,8,5))

HTH


"Dave F" wrote:

Assume A1 has the number of widgets ordered.

Then:

=IF(A1=95,10,IF(A1=105,5))

If you want to avoid the FALSE value, you have to either specify what
your
ELSE clause is, which you haven't done, or, otherwise, suppress
errors, as
in:

=IF(A1=95,10,IF(A1=105,5,"")) In plain English this says: "IF A1 is
95,
THEN 10, ELSE IF A1 is 105, THEN 5, ELSE return an empty string."

Dave
--
Brevity is the soul of wit.


"Jackiec21" wrote:

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!