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

I have the same question (0)

All responses (4)

Answers (1)

Manish Solanki 15,167 Moderator on at

Like (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.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (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))

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
int( formatNumber( add( item(), 0.49999999999999 ), '#' ) )

Was this reply helpful? Yes No
Expiscornovus 33,828 Most Valuable Professional on at

Like (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 🙂

Was this reply helpful? Yes No