There are several functions in Excel that literally serve to “find the cell in time and space”. They can be used to identify the row and column in which the cell is located, count the rows or columns, determine the type of value that the cell contains … By themselves, these functions are seldom used. In combination with other functions, in conditional formatting, and especially with data validation, they can be irreplaceable.
Besides basic calculating operators like addition (+), subtraction (-), multiplication (*), and division (/) Excel contains even a handful of functions that we can use to perform various mathematical operations. Also, there are functions for calculating the absolute value, returning the number sign, and some other functions that can be of importance, for example, to create conditions in conditional formatting, when we want to color each different order in different colors …