#LibreOffice Calc Functions

 

 

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

 How to open

 

Mathematical Functions

Sum()

It adds all the numbers in range of cells .

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

=Sum(339,10) 349

 

Round()

it rounds a number to a Specified number of digits

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

=Round(4.754,1) 4.7

 

Roundup()

it rounds a number up away from Zero.

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

=Roundup(5.27,1) 5.3

 

Rounddown()

it rounds a number down towords Zero.

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

=Rounddown(6.27,1) 6.2

 

ABS()

it returns the absolute value of a number .

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

=ABS(-9) 9

 

SQRT()

it returns a positive square root of a number.

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

=SQRT(144) 12

 

TRUNC()

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

of the number.

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

=TRUNC(-3.9) -3

 

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>40,"Fail", ))

 

True()

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

Ex =8>7  True

 

False()

it returns the logical value False and it takes no arguments

 Ex   =3>4 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

 

Time()

it returns the current date.

Syn------- =Time(hh,mm,ss)

                                =Time(7,1,5)    07:01:05 

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("/5/1/2019") 2019

 

Text Function()

Concatenate()

Joins two or more text strings into one text string.

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

=Concatenate("madan", singh") madan singh

 

Left()

it is used for given text left , according to given number.

=LEFT(L9,4)

Ex- manohar laal    mano

Right()

it is used for given text left , according to given number.

=Right(L9,4)

Ex- manohar laal laal

 

 

Financial Funcion

SLN()

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

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

=SLN(800000,3500,40)

 

PMT()

it is used for calcualting MI Means Monthly Installment.

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

=PMT(20%/12,60,300000)