Last night I talked with an administrative friend in my office, he told me what excel formulas he often uses in doing his work, here are some formulas ...
Excel Percentage Formula
Formula Persentase = Number1 / Number Total
Excel SUM Formula
SUM formula in Excel is used to add more than 2 variables, example:
Formula SUM = SUM(number1:number2)
Excel Average Formula
The average formula is used to find the average value of a list, example:
Formula Average = AVERAGE(number1:number2)
Excel Max Formula
The max formula is used to find the highest value of a series of values, example:
Formula Max = MAX(number1:number2)
Excel Min Formula
The max formula is used to find the lowest value of a series of values, example:
Formula Min = MIN(number1:number2)
Excel IF Formula
The function of the Excel IF formula is to provide results adjusting to the values in a column, example:
Formula IF = IF(C6>10000;”MAHAL”;”MURAH”)
Excel Left Formula
The function of the Excel LEFT formula is to take several characters in a word or row of numbers, in order from left to right, example:
Formula LEFT = LEFT(cell to retrieve; number of characters to be displayed)
Excel Mid Formula
The function of the Excel MID formula is to take several characters in a word or a series of numbers, with a sequence of characters ranging from the order to how many and how many characters are taken, example:
Formula MID = MID(cell to be retrieved; starting from the number of characters; the number of characters to be displayed).
Excel Clean Formula
The function of the Excel CLEAN formula is to eliminate non-printable characters, example:
Formula Clean = CLEAN(Text).
Thanks for read mydocs, hope your enjoy it.
Top comments (0)