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...