Formula Help

J

Jim87

I am in the precess of finalising electronic rosters for a small company and
cannot seem to find a way to incorperate a manning guide successfully.

I simply wish to be able to display a number of my choice in one colum and e
related number in my second colum.

eg
Range of 0 to 300 to equal 3
Range of 301 - 455 to equal 4
Range of 456 to 707 to equal 5

any help would be great
 
P

Pete_UK

Try this, assuming the determining number is in A1:

=IF(A1<=300,3,IF(A1<=455,4,5))

You didn't say what you wanted if the number was above 707, so this
formula will still return 5 in that situation. If you wanted to return
some other value (eg 6) if the number exceeded 707, then amend it to
this:

=IF(A1<=300,3,IF(A1<=455,4,IF(A1<=707,5,6)))

Hope this helps.

Pete
 
Top