Greater/Less Than or Equal To
 

I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each,
and 100+ is $11. I need to put a formula into a column that can calculate
this automatically. The cell with the final quantity is T10, so the first
part of the equation should look something like this:

=IF(T10<31, 13)

That works for all numbers less than 31, but I need the other two parts
added in there. Please help.

Greater/Less Than or Equal To
 

=IF(T10<31,13,IF(T10<100,12,11))

Hoov wrote:
I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each,
and 100+ is $11. I need to put a formula into a column that can calculate
this automatically. The cell with the final quantity is T10, so the first
part of the equation should look something like this:

=IF(T10<31, 13)

That works for all numbers less than 31, but I need the other two parts
added in there. Please help.

Greater/Less Than or Equal To
 

One way.......

=IF(T10<31,13,IF(T10<100,12,11))

Vaya con Dios,
Chuck, CABGx3



"Hoov" wrote:

I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each,
and 100+ is $11. I need to put a formula into a column that can calculate
this automatically. The cell with the final quantity is T10, so the first
part of the equation should look something like this:

=IF(T10<31, 13)

That works for all numbers less than 31, but I need the other two parts
added in there. Please help.

Greater/Less Than or Equal To
 

Hi

=IF(T10="","",IF(T1099,11,IF(T1030,12,13)))
or, marginally shorter,
=IF(T10="","",11+(T10<100)*2+(T10<31)*1)

--
Regards
Roger Govier

"Hoov" wrote in message
...
I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each,
and 100+ is $11. I need to put a formula into a column that can calculate
this automatically. The cell with the final quantity is T10, so the first
part of the equation should look something like this:

=IF(T10<31, 13)

That works for all numbers less than 31, but I need the other two parts
added in there. Please help.

Greater/Less Than or Equal To
 

=IF(T10<=30, 13, IF(T10<=99, 12, 11))
--
David Biddulph

"Hoov" wrote in message
...
I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each,
and 100+ is $11. I need to put a formula into a column that can calculate
this automatically. The cell with the final quantity is T10, so the first
part of the equation should look something like this:

=IF(T10<31, 13)

That works for all numbers less than 31, but I need the other two parts
added in there. Please help.

Greater/Less Than or Equal To
 

Give this formula a try...

=11+(A1<100)+(A1<31)

--
Rick (MVP - Excel)


"Hoov" wrote in message
...
I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each,
and 100+ is $11. I need to put a formula into a column that can calculate
this automatically. The cell with the final quantity is T10, so the first
part of the equation should look something like this:

=IF(T10<31, 13)

That works for all numbers less than 31, but I need the other two parts
added in there. Please help.