In Microsoft Excel, calculating or calculating data can be made easier by entering a formula. Every time you use a basic formula, you must start it with an equal sign "=" because the basic formula cannot function if it is not preceded by an equal sign "=".
Apart from that, the address of the dara also needs to be paid attention to and paid attention to, because if you type the address incorrectly, the results will be wrong or the message "#VALUE" will appear. Following are the details of the formula that you can use for data calculations:
1. Basic arithmetic
Basic arithmetic in Microsoft Excel contains addition (+), subtraction (-), multiplication (*), and division (/) operations.
2. SUM
SUM is used to add up a set of data in a range. Example of writing: =SUM(Number 1; Number 2)
3. MIN
MIN is used to calculate the minimum value or find the lowest value in a set of range data. Example of writing: =MIN(Number 1; Number 2)
4. MAX
MAX is used to calculate the maximum value or find the highest value in a set of range data. Writing example: =MAX(Number 1; Number 2)
5. AVERAGE
AVERAGE is used to calculate the average value of data in a range. Example of writing: =AVERAGE(Number 1; Number 2)
6. COUNT IF
COUNT IF is used to count or enumerate a predetermined range. Writing example: =COUNTIF9Range; Criteria)
7. COUNT
COUNT is used to count the entire amount of data from the selected range. Writing example: =COUNT(Value 1; Value 2)
8. COUNTA
COUNTA is used to count the number of non-empty cells in the range. Example of writing: =COUNTA(Value 1; Value 2) Also read: Understanding Cell Format and Number Types in Microsoft Excel
9. SUM IF
SUM IF is used to calculate the number in a data range with certain criteria. Writing example: =SUMIF(range; criteria;[sum_range])
10. IF
IF is used as a logical formula to determine the value of a statement where the IF function will determine a decision based on certain conditions. Writing example: =IF(logical_test, value_if_true, value_if_false)
11. VLOOKUP
VLOOKUP is used to look for values in a vertical (upright) table column. Example of writing: =VLOOKUP(lookup_value, table_array, col_index_num,[range_lookup])
12. HLOOKUP
HLOOKUP is used to look for values in a horizontal table column. Writing example: =HLOOKUP(lookup_value, table_array, col_index_num,[range_lookup])
