#### Overview of this book

Part 1 – Introduction and Getting Started
Free Chapter
Chapter 1: Getting Started with AppSheet
Part 2 – App Editor and Main Features
Chapter 2: Understanding App Editor and Data Sources
Chapter 3: Presenting App Data with UX/Views
Chapter 5: Manipulating Data with Behaviors and Actions
Chapter 6: Controlling App Users and Data Security
Chapter 7: Managing the App Environment
Part 3 – Advanced Features and External Services
Chapter 8: Automating Recurring Data Changes and Scheduling Tasks
Chapter 9: Using Intelligence and Advanced Features
Chapter 10: Extending App Capabilities with Third-Party Services
Part 4 – App Templates and Tricks for App Building
Chapter 11: Building More Apps with App Templates
Chapter 12: Tips and Tricks
Chapter 13: Appendix
Index
Other Books You May Enjoy

# Performing arithmetic calculations with math functions and expressions

We will learn about the most used math functions in this section. Math functions are mostly useful in numerical calculations and data presentations. You may want to show the user a rounded-off distance value, in kilometers, as an integer, rather than the calculated distance with decimals. You can achieve this using math functions and expressions:

Table 4.23 – Math functions – FLOOR(), CEILING(), and ROUND()

Let us next learn how to use the `MOD()` function to find the arithmetic remainder when we divide one integer by another:

Table 4.24 – Math function of MOD()

Let us next learn about the `SUM()` function, which adds all the values in a numerical-type list:

Table 4.25 – SUM() function

At times, you want to compute a random number within a number range. You can use the `RANDBETWEEN()` function to compute a random integer...