In order to create files and tables, we usually take help of Microsoft Excel. Microsoft Excel is a spreadsheet program. This spreadsheet program is also a part of Microsoft Office. The spreadsheet is a pop format that presents tables having values arranged according to the rows and columns. These values can be manipulated mathematically by using the common Microsoft Excel formulas and functions. Here in this article, Amar Majhu is going to provide you with details about the some basic Excel formulas that are important for your workflow.
The first and most common formula that is used in Microsoft Excel is SUM. The function of the SUM is to get an aggregate of the values given in the rows or columns selected.
The formula to get the total of the values given =SUM(number1, [number2], …)
The average function works like the simple average formula you have earlier read in your mathematics. For example the average number of articles prepared in a month. Average is normally calculated as the total number of articles divided by a number of days in a month.
Formula to find the average in given value =AVERAGE(number1, [number2], …)
Count functions help in getting the total of all the cells that are provided in a given range. Count function counts rows cells that contain numeric values only. Alpha values do not get counted by this function.
The formula to put if you want to count the numeric values given =COUNT(value1, [value2], …)
Unlike the count function that COUNTA function also helps in counting the cells that are given in a particular range. In the count function only numeric values can be counted but in the COUNTA function, all the cells having values in their numeric or non-numeric will be counted. Furthermore, this function also counts dates, times, strings, logical values, errors, empty string, or text.
The formula to put if you want to count all the values =COUNTA(value1, [value2], …)
Whenever you are required to provide the data according to the logic available then the if function will be used. The best part about using this function is that you can set up formulas and functions inside it also.
Formula to put the IF Function =IF(logical_test, [value_if_true], [value_if_false])
With the help of the trims function, you can easily eliminate all the empty spaces that are available in the spreadsheet. The fact that should be considered while using the trim function is that it can only be operated on a single cell. Furthermore, there is a downside of this function and that is sometimes it adds duplicate data in your spreadsheets.
The formula to trim the text=TRIM(text)
7. MAX & MIN
The MAX and MIN function will help you in getting the maximum number and minimum number in a particular value.
Formula to find Minimum Value: =MIN(number1, [number2], …)
Formula to find Maximum Value: =MAX(number1, [number2], …)
Hence these are some of the formulae you must be aware of if you are using the Excel Suite. These formulas given by Amar Majhu will help you in doing the workflow with ease.