Separate the decimal number

[Jeff_Hager]

Check out this thread.

TRUNC function in Math column or send results to sheet?

Check out the concept I made here in the Trunc test tab. What I did behind the scenes, assuming Dave only needs positive numbers as inputs. [image] A math column & template column to round the number up to integer. A delta column = number - integer temp. The helper column is 1 + delta column. Final value: If delta less than 0 then helper, if delta equals 0 then 0, else delta.