IF is Integer?

I have a formula column that is constantly changing and bringing in live information. If the numbers are integers, I want to see them rounded with no decimal point. If the numbers do have decimals, I want to see only 1 decimal place. Pressing the increase/decrease decimal button doesn't help, since I need it to depend on if the number is an integer or not.

For example, I want to see the cells on the left column in the picture, not the ones on the right:

Screen Shot 2021-07-27 at 8.42.26 PM.png

These cells are live and always changing so I can't use the increase/decrease decimal buttons.

Can I use the INT function for this? Or do I need to do something fancy with RIGHT and LEN?

Thank you

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @SYSPK

Hope you are fine, please try to use the following formula and convert it to column format formula:

=IF(ISBLANK(Original@row), "", IF(FIND(".", Original@row) >= 1, Original@row, INT(Original@row)))

the following screenshot shows the result:

All comments

Bassam Khalil

Hi @SYSPK

Hope you are fine, please try to use the following formula and convert it to column format formula:

=IF(ISBLANK(Original@row), "", IF(FIND(".", Original@row) >= 1, Original@row, INT(Original@row)))

the following screenshot shows the result:

SYSPK

@Bassam Khalil Thank you that seems to be the right function.

Now another problem- this column I had already make an integer column I guess by pressing the remove decimal button. Now I can't get it to reset. Even with this formula, I can only see integers. Is there any way I can reset that column so I can let the function do its work?

Screen Shot 2021-07-27 at 9.51.36 PM.png

Bassam Khalil

@SYSPK

Try the opposite by increasing the decimal

SYSPK

That didn't work but I was able to reset it by using the paintbrush from another column.

Thanks

Bassam Khalil

@SYSPK

Excellent.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.