Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
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 |