View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hoov Hoov is offline
external usenet poster
 
Posts: 12
Default 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.