Remember Me?

#1
May 14th 09, 03:54 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 12
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

#2
May 14th 09, 04:01 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 2,819
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

#3
May 14th 09, 04:06 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,998
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

#4
May 14th 09, 04:10 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2,480
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

#5
May 14th 09, 04:41 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
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

#6
May 14th 09, 05:54 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 5,934
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post sonicj Excel Discussion (Misc queries) 4 May 1st 08 09:02 PM Millington Excel Discussion (Misc queries) 4 June 17th 07 04:51 AM Brandon Excel Discussion (Misc queries) 2 July 18th 06 11:34 PM [email protected] Excel Worksheet Functions 3 February 5th 06 08:34 AM dazman Excel Worksheet Functions 1 August 7th 05 05:59 PM

All times are GMT +1. The time now is 06:44 AM.