If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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 030 items, they are $13 a piece, 3199 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. 
Ads 
#2




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 030 items, they are $13 a piece, 3199 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. 
#3




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 030 items, they are $13 a piece, 3199 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. 
#4




Greater/Less Than or Equal To
Hi
=IF(T10="","",IF(T10>99,11,IF(T10>30,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 030 items, they are $13 a piece, 3199 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. 
#5




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 030 items, they are $13 a piece, 3199 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. 
#6




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 030 items, they are $13 a piece, 3199 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. 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
IF with Equal to or Greater than  sonicj  Excel Discussion (Misc queries)  4  May 1st 08 09:02 PM 
Greater Than/Equal To Formula  Millington  Excel Discussion (Misc queries)  4  June 17th 07 04:51 AM 
Greater than or equal to (Plus or minus)  Brandon  Excel Discussion (Misc queries)  2  July 18th 06 11:34 PM 
First occurance greater than or equal to a specified value  [email protected]  Excel Worksheet Functions  3  February 5th 06 07:34 AM 
Vlookup but also equal to and greater than?  dazman  Excel Worksheet Functions  1  August 7th 05 05:59 PM 