Answered

Round up to next whole number

(0) Share

Report

Posted on by pranavj619

I want to round up to the next whole number. If the value is 0.12 it should round up to 1. irrespective of what value is there after the decimal...just want to round up to the next whole number

What can be done?

Categories:

General topics

All responses (4)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please use the following formula:

If(Value(Left((Last(Split(TextInput2.Text,".")).Value),1)) < 5 And Mod(TextInput2.Text,1)>0,Round(Value(TextInput2.Text) + 1,0),Round(Value(TextInput2.Text),0))

Where, TextInput2 is the input decimal value that needs to be rounded off.
Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @pranavj619,

As a workaround, you could check if a dot is available via an indexOf function. If so, you could split on the dot and use an add function to add 1 number and round up to the next whole number.

Try an expression like below:

if(equals(indexOf(string(outputs('Compose')), '.'), -1), outputs('Compose'), add(int(split(string(outputs('Compose')), '.')[0]), 1))
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
int( formatNumber( add( item(), 0.49999999999999 ), '#' ) )
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Chriddle,

That is a great solution. I was thinking about the # specifier as well, used that before with rounding up.

But I didn't think of adding the 0.49999999 part for this scenario. Nice suggestion 🙂