Using an IF function, with an exception

I have a column of codes. The codes are numbers with one decimal place and range from 1.0 to 3.9.

Each of these codes resides in a section. It's pretty simple... any codes between (and inclusive of) 1.0 and 1.9 are in section "1", 2.0-2.9 = section "2", and 3.0-3.9 = section "3". There is one exception. Code 2.5 actually resides in section "3".

I'd like to look at the column of codes, and in the next column, have Excel determine what section that code belongs in.

Currently, I'm using the following function to assign a code, but it does not take into account the single exception. Can anyone help?

Please Login or Register  to view this content.

Try

=IF(A2="","",IF(A2=2.5,3,INT(A2)))

If you need the result to be text change to

=IF(A2="","",IF(A2=2.5,3,INT(A2)))&""

That did the trick... thanks!