As it is currently configured, AppSheet expressions can be pieced together to perform virtually any rounding operation you might desire. It’s not always easy, however. I think the following kind of ROUND() expression would simplify many rounding tasks:
This screenshot was taken from a page about Google sheets’ ROUND() function. AppSheet has ROUND() but does not have the capability to determine where the rounding should occur.
I’ve written a bit about this here:
This is in response to @Steve’s very useful tip about integers vs. decimals in AppSheet.
By the way, here’s an example of a strategy for rounding in AppSheet that would continue to be necessary, even if the ROUND() expression were made more powerful: