Rounding Function

[RandyD123]

I have a column of numbers in the "I" column. It runs from I8:I31. This column is populated based on info from another tab. So the existing formula in that column starting with "I8" is "=Output!AD5 and runs to "I31" which is "=Output!AD28"

What I need is a formula or conditional formatting that will do the following:

Any number in the "I" column that is more than 0.1 to .99 has to round up to 1.0
Any number in the "I" column that is greater than 1.0 will follow normal rounding rules, meaning 1.1 - 1.4 will round down to 1.0 and 1.5 and above will round up to 2.0......and so on.

Thanks in advance for any help.

 

[RoryA]

Perhaps:

=IF(I8<1,roundup(I8,0),ROUND(I8,0))

 

[RandyD123]

But don't I have to have the Original Number from the output sheet built into the formula?

 

[RoryA]

If you want the formula in the I column, then replace the references to I8 with whatever cell that is linked to currently.

 

[bebo021999]

May be?
=IF(Output!AD5<1,roundup(Output!AD5,0),ROUND(Output!AD5,0))

 

[RandyD123]

May be?
=IF(Output!AD5<1,roundup(Output!AD5,0),ROUND(Output!AD5,0))

Thank You. Works Perfectly!!!