Help with multiple if function

[floricita]

Hi,

I want to write a formula that says, if cell T1 falls in the range of 0-336, then write 1, if it falls between 337-503, then write 2, 504--671,3,672-839,4,840-950,5,951-1118,6,1119-1229,7,1230-1398,8,1399-1454,9,over1455,10

Is there a formula that can do this?

any help would be appreciated. thanks

[zbor]

Here, try this:

=LOOKUP(A1,{0,337,504,672,840,951,1119,1230,1399,1455},{1,2,3,4,5,6,7,8,9,10})

[floricita]

Thanks mate, just changed a1 to t1 and it works perfectly.

thank you again

[Marcol]

Only as a matter of interest. This can be handy to use under some conditions.

You can split the ifs into two (or more) cells
Say in B1 and C1
In B1

Please Login or Register  to view this content.

In C1

Please Login or Register  to view this content.

Go with zbor in this case