The IF Formula Help

[craig_partizan]

hello all,

i would like to work out a formula that if the total of my cells is 150 or less i will require 1 of something
if the total is between 151 and 300 i want it to show 2 etc. please see below

1-150 i will need 1
151-300 i will need 2
301-450 i will need 3

and so this will carry on and on.

would an If formula work in this scenario?

any help will be greatly appreciated

Kind regards

Craig

[Tony Valko]

An IF formula would work but if you have many levels a lookup formula would be better.

See if this helps:

http://contextures.com/xlFunctions02.html

[benishiryo]

welcome to the forum, Craig. not really sure if you really wish to show 1-3 or is it just an eg. if it seems to be multiples of 150, then maybe:
=CEILING(A1/150,1)

if it's more than that, do up a table say in column F & G. type the minimum number of the range in column F. so it should be:
1
151
301

then type the desired results in column G.
1
2
3

do this formula:
=LOOKUP(A1,$F$1:$F$3,$G$1:$G$3)