Excel Functions

Functions are predefined formulas or programs that perform calculations,in excel on Specific values, called arguments Each function takes specific types of arguments such as numbers, references, text or logical values.

Mathematical Functions

Sum()

It adds all the numbers in range of cells .

Syntax------- =Sum(number1,number2)

=Sum(59,10) 69

Round()

it rounds a number to a Specified number of digits

Syn-------- =Round(number, num_digits)

=Round(6.754,1) 6.7

Roundup()

it rounds a number up away from Zero.

Syn---------- =Roundup(number, number_digits)

=Roundup(3.27,1) 3.3

Rounddown()

it rounds a number down towords Zero.

Syn----------- =Rounddown(Number, numberdigits)

=Rounddown(3.27,1) 3.2

ABS()

it returns the absolute value of a number .

Syn------------- =ABS(num)

=ABS(-5) 5

SQRT()

it returns a positive square root of a number.

Syn------------ =SQRT(num)

=SQRT(16) 4

TRUNC()

it truncates a number to an integer value by removing the fractional part

of the number.

Syn----------- =TRUNC(num, Num_digits)

=TRUNC(-8.9) -8

Logical Function ()

IF()

it is used to determine whether a condition specified within braces is true

or false.

Syn--------------IF(Logical_test, Value, Value_if_true, Value_if_false)

IF(K2>60,"A", if(K2>55,"B", ))

True()

it returns the logical value TRUE and it takes no arguments.

Syn--------=IF(A1<0,True())

False()

it returns the logical value False and it takes no arguments

Syn---------=IF(A1>0,False())

Statistical Function

Max()

it returns the largest value in a set of values stored in cells.

Syn----------- =Max(number1,number2...)

=Max(40,32,29) 40

Min()

it returns the smallest value in a set of values stored in cells.

Syn-----------=Min(number1, number2.....)

=Min(4,2,1) 1

Average()

the average function returns the average of the argument which are passed in function.

Syn-----------=Average(number1,number2...........)

=Average(34,24)

Count()

it counts the number of cells that contain numbers within the list of arguments.

Syn------------ =Count(Value1,Value2...)

=Count(40,34) 2

Date and Time function

Today()

it returns the current date of the system .

Syn-----=Today() 25/3/2019

Now()

it returns the current date and time.

Syn------- =Now() 25/3/2019 8:40AM

Day()

it returns the day of a date passed as an argument.

Syn---------=Day("6-jan") 6

Month()

it returns the month of a date passed as an argument.

Syn--------=Month("1-oct") 10

Year()

it returns year to a corresponding year to a date.

Syn--------=Year("2019/5/1") 2019

Text Function()

Concatenate()

Joins two or more text strings into one text string.

Syn--------=Concatenate(text1,text2......)

=Concatenat("madan", singh") madan singh

Left()

Right()

Financial Funcion

SLN()

it returns the straight line depreciation of an asset for one period.

Syn-----------=SLN(Cost, Last Value, Life)

=SLN(100000,7500,10) 9250

PMT()

it is used for calcualting MI Means Monthly Installment.

Syn-----------=PMT(Rate, Nper, Pv)

=PMT(15%/12,60,100000) 2378.99