Excel formulas are divided into two, namely formula formulas and function formulas. Formulas: Excel formulas manually typed by users of this application. Like the formula “=B1+B2+B3” or “=C1-C2/C3”.
Meanwhile, function formulas are formula templates provided by Microsoft Excel. For example the formula “=SUM(A1:A3)” or “MIN(A1:A5)”.
Below are the purposes of the most frequently used Excel formulas:
SUM is an Excel formula for adding a list of numbers, so you can get a quick total or know how much money is left in your savings account.
The formula is =SUM(A2:A6)
2. MAXIMUM and MIN
MAX and MIN are formulas for determining the maximum or minimum value of a given data set. For example, searching for the highest value in a numeric column or searching for the lowest value in a numeric column.
The smallest: =MIN(A2:A13)
Follow Okezone news on Google News
The following content is presented by the advertiser. Okezone.com journalists are not involved in this content material.
Quoted From Many Source