Home 
Search 
Today's Posts 
#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. 
#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(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 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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
IF with Equal to or Greater than  Excel Discussion (Misc queries)  
Greater Than/Equal To Formula  Excel Discussion (Misc queries)  
Greater than or equal to (Plus or minus)  Excel Discussion (Misc queries)  
First occurance greater than or equal to a specified value  Excel Worksheet Functions  
Vlookup but also equal to and greater than?  Excel Worksheet Functions 