Functions are used in MS Excel

Some commonly used Functions

There are most recently or commonly used functions are as followings.

Function Syntax Purpose

=Sum(range) For addition of cells or values

=product(range) For multiplication of cells / values

=average(range) For average of cells or values

=max(range) For Maximum value of range

=min(range) For minimum value of range

=count(range) For counting of numeric values

=counta(range) Count the numbers of cells that are not empty.

=countblank(range) Count the empty cells in the range

=countif(range, criteria) Count the number of cells within a range that meet the condition.

=today() Shows the today date

=now() Shows the current date with time

=days360(St_date,En_date) Return the number of days between two dates.

=day(date) Return the day from the date

=month(date) Return the month from the date

=power(value,power) Calculate the result of number raised powers

=sumif(range, criteria,sum_range) adds all numbers in a range of cells, based on a given criteria.

=If(condition,value_if_ture,value_if_false) The IF function is used to make decisions.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.