Jun 11 2021 05:12 PM
Hello! Is there a way to set a field to round up to the nearest whole dollar when you don't know what the starting dollar amount will be? I don't believe ROUNDUP will work for this.
What's happening is that I'm taking a dollar amount (which is variable) and auto-calculating 3% of it. I need the resulting dollar amount (the 3% amount) to round up to the next whole dollar. It has to round UP. That part is key.
For example, 3% of $3,890 is $116.70, but I need a formula or setting that will return a result of $117.
Thanks!
Jun 11 2021 09:51 PM
Jun 12 2021 03:12 AM