Discussion of Simple IF Logic Formulas | SUM AVERAGE MIN MAX in EXCEL | Office Technology
Discussion of Simple IF Logic Formulas | SUM AVERAGE MIN MAX in EXCEL | Office Technology
Excel formulas don't have to be memorized; let's try analogizing them with the simple explanation in this video.
Download the practice file at the following link:
bit.ly/excelbag1
The sum function is used to sum multiple cells.
The max function is used to find the highest value among multiple cells.
The min function is used to find the lowest value among multiple cells.
The if function is used as an "If" or "Then" analogy.
The average function is used to find the average value among multiple cells.