Top 10 Basic excel Formulas That You Should
Know
Don’t waste any more hours in Microsoft Excel doing things
manually. Excel formulas decrease the amount of time you spend in Excel and
increase the accuracy of your data and your reports.
|
Name of Formulas
|
Formula
|
Description
|
|
SUM
|
=SUM ( Number1, Number2, … )
|
Add all numbers within range resulted into sum of all
numbers
|
|
AVERAGE
|
=AVERAGE(number1, [number2],…)
|
Calculate average numbers in a range
|
|
MAX
|
=MAX( Number1, Number2, … )
|
Calculate or find largest number in specific range
|
|
MIN
|
=MIN( Number1, Number2, … )
|
Calculate or find smallest number in specific range
|
|
TODAY
|
=TODAY()
|
Returns the current date
|
|
UPPER
|
=UPPER(text)
|
Converts text to uppercase.
|
|
LOWER
|
=LOWER(text)
|
Converts text into lowercase.
|
|
Countif
|
=COUNTIF(range, criteria)
|
This function counts the number of cells within a range
that meet a single criterion that you specify.
|
|
counta
|
= COUNTA(value1, [value2], …)
|
This function counts the number of cells that are not
empty in a range.
|
|
ABS
|
= ABS(number)
|
ABS function returns a value of the same
type that is passed to it specifying the absolute value of a number.
|
No comments:
Post a Comment