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. |
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 |