# TRUNC function in Math column or send results to sheet?

**URL:** <https://community.glideapps.com/t/trunc-function-in-math-column-or-send-results-to-sheet/14863>\
**Category:** Feature Requests\
**Created:** [August 28, 2020, 4:48am UTC](https://community.glideapps.com/t/trunc-function-in-math-column-or-send-results-to-sheet/14863 "2020-08-28T04:48:12Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 28, 2020, 7:50am UTC](https://community.glideapps.com/t/trunc-function-in-math-column-or-send-results-to-sheet/14863/5 "2020-08-28T07:50:17Z")

</div>

Check out the concept I made here in the Trunc test tab.

> **[Thinh Dinh's lab](https://tdslab.glideapp.io/)**
>
> Thinh Dinh's place to test out new concepts

What I did behind the scenes, assuming Dave only needs positive numbers as inputs.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/02a3a2adc5d8e4531a54a3d3696f63674ef4e941.png)

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.

---

_[View the full topic](https://community.glideapps.com/t/trunc-function-in-math-column-or-send-results-to-sheet/14863)._