Integers are rounded decimals are only taken to 2 decimal places and rounded

[metrostar]

The cell value is an integer, and the integer is reserved, but the cell value has a decimal point, and only 2 decimal points can be reserved

4 rounded to 5

Column J is the input area, and the data will immediately get results like column L after input

Column L does not exist, it is just a reference value

congratulations merry christmas everyone

Any help would be appreciated!

[JohnTopley]

Try

=IF(MOD($J2,1)=0,$J2,ROUND($J2,2))

[metrostar]

Try

=IF(MOD($J2,1)=0,$J2,ROUND($J2,2))

JohnTopley, the formula you gave is correct, thank you, can the user input in column J (no helper column) also get the same result?

[kvsrinivasamurthy]

In M2 copied down

=IF(J2="","",CEILING(J2,0.01))

[JohnTopley]

You will need VBA if you want result in the input cell

Please Login or Register  to view this content.

Right Click on sheet tab, "View Code", copy/paste above code.

[metrostar]

Thank you kvsrinivasamurthy ,
Thank you JohnTopley ,You are amazing