Greater/Less Than or Equal To

H

Hoov

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

Roger Govier

Hi

=IF(T10="","",IF(T10>99,11,IF(T10>30,12,13)))
or, marginally shorter,
=IF(T10="","",11+(T10<100)*2+(T10<31)*1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Less or Equal 3
Excel less than greater than formula 1
Multiplying Values only less than 1.5 1
Greater and less than 4
Nested Greater than or less than Formula 4
Multiple conditions using greater than or less than. 1
Greater than, less than, AS WELL AS value=0 5
Sumif number is greater than a number but less than another number 2

Top