Skip to main content

2017年9月21日 04:55

How do I always round upwards to one decimal place in a formula?

I need to replicate an Excel formula in a Salesforce formula field so that if the result is always rounded upwards to one decimal place, e.g.

2.11111 = 2.2

2.0001 = 2.1

The Excel formula uses ROUNDUP but there's no equivalent in Salesforce. CEILING goes to a full integer and ROUND can go up or down.

3 个回答

David Hales (Kloudrac Software Private Limited)
2017年9月21日 05:02
Hi Teo ,

Please look at this link , Hopefully it helps you .

https://success.salesforce.com/answers?id=90630000000gzhRAAQ

https://developer.salesforce.com/forums/?id=906F00000008uPHIAY

I hope your Issue is resolved.

Please Mark this as best answer in case your query is resolved.

Best Regards

David Hales(1058)

添加评论

撰写回答...

0/9000