Rounding Down

[hemant86]

Hi All,

I have got a pretty unique requirement for rounding numbers. I want the result as 7 if my output is 7.5 and 8 if the output is more than 7.5

Ex:

7.5 = 7

7.6 = 8

Is there any workaround for this.

Thanks in advance.

[atcodedog05 · Accepted solution]

Hi @hemant86 

Use formula

Round([Field1]-0.1, 1)

Workflow:

Hope this helps : )

[hemant86 · Accepted solution]

Thanks @atcodedog05 That was amazing. That's way more simple than I thought. 🙂 Two thumbs Up to You!

[atcodedog05]

Happy to help : ) @hemant86 

Cheers and have a nice day!