IF statement to round numbers - HELP PLEASE!!

[sam.tidswell-norrish]

I have column C with values ranging from 1 through to 3 (with decimal points etc.) How do I create a formula to round the values to 1 if less than 2, to 2 if between 2-3, and 3 if 3 and above?

I believe the start of the formula would be: =IF(C1<2,"1")

But then I do not know how to add in the other parts of the formula...

Please help, thank you!

 

[VoG]

Try

=MIN(3,FLOOR(C1,1))

 

[Ruddles]

Is this it?

=if(c1<2,1,if(c1<3,2,3))

or:-

=if(c1>3,3,if(c1>2,2,1))

 

[sam.tidswell-norrish]

Unfortunately none of them work... 2 is still counted as 1... I basically need anything that begins with a 1 to be a 1, 2 to be a 2 and 3 to be a 3...

Ie/ 1.3 = 1
2.2 = 2 etc

 

[VoG]

It works for me

Excel Workbook
	C	D
1	1.3	1
2	2.2	2
3	3	3
4	3.4	3
5	5	3
Sheet6

or maybe just =INT(C1)

 

[Michael M]

I think I'm the same as Ruddles, but it works for me

=IF(C1<2,1,IF(C1<3,2,3))

 

[sam.tidswell-norrish]

Thank you!