Rounding up from 5?

General FAQs
, ,
1

Hello! I was wondering if there was a way of having a number round itself up if it ends in 5. For example,

88.705 would round to 88.71.

Right now, I’m using the ROUND function to round things to two decimal places. The thing with this function is that it rounds up numbers ending in 6 and up, instead of the traditional 5 and up. Is it possible to create a formula that rounds up from 5 instead of 6?

2

@dylannguyen

What you are asking for IS the way it works. I suspect what you are seeing at 88.705 is already a rounded value displaying with 3 decimal places. The actual value is probably something like 88.704913333333333.

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like