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.

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.

3 Likes