Rounding numbers to specific integers

[Kagemucha]

Hey, I was wondering if anyone could help me out on this problem. I'm trying to round off my numbers to specific integers. Sorta like a step function (in algebraic terms).

For example, my first few intgers are 0-8-13. I want: 0<=X<8, 8<=X<13, etc.

So far, this is what I have:

=IF(C2>=0,IF(C2>=8,IF(C2>=13, IF(C2>=20, IF(C2>=35, IF(C2>=55, IF(C2>=85, IF(C2>=125, "blank", 85), 55), 35), 20), 13), 8 ),0 ), "blank2")

It seems to work perfectly to there. However, when I try and enter the next set, an error pops up. This is what didn't work:

=IF(C2>=0,IF(C2>=8,IF(C2>=13, IF(C2>=20, IF(C2>=35, IF(C2>=55, IF(C2>=85, IF(C2>=125, IF(C2>=200, "blank", 125), 85), 55), 35), 20), 13), 8 ),0 ), "blank2")

The bold being the new things that I added.

*C2 is where the raw data is inputted

[Mallycat]

What is the purpose of what you are trying to do. Are you saying that you want to round any random number to 0, 8, or 13? ie if I were to select 9, it would round to 8. If I select 11, it would round to 13? Is this what you want?

Matt

[Kagemucha]

I want all numbers 8<=X<13, <=13<20, etc. So all numbers greater than 8 but less than 13.

So using your example, if you chose 9 it would turn to 8. if you choose 11 it would also be 8 since the next round able integer is 13, and 11<13.

[Mallycat]

Try this in cell C3

=CHOOSE(MATCH(C2,{0,8,13},1),0,8,13)

EDIT: Better still, try this =LOOKUP(C2,{0,8,13})

Matt

[Kagemucha]

Wow. Thank you very much. I've never known about any of those functions you just mentioned :P

I tried both, they work perfectly. Thanks!