Forum Discussion
Help to customise rounding numbers
Good afternoon, Could you please help me with this one, I'm trying to round up numbers, but I need that if they are greater than %.8 then go to the closest whole number and when %.7 then decreasing...
You could do this
Uneven Round= IF(X - TRUNC(X) >=0.8 , ROUNDUP(X ,0) , ROUNDDOWN( X , 0 ) )With X being the column you want to round unevenly.
You could do this
Uneven Round= IF(X - TRUNC(X) >=0.8 , ROUNDUP(X ,0) , ROUNDDOWN( X , 0 ) )
With X being the column you want to round unevenly.
It worked perfectly!!! Thank you so much!!