Function Wizard

Function wizard

The function wizard is a tool that helps us to find we want through the library and secondly to introduce the arguments step by step and with the correct syntax. There are following categories available in function wizard- 

a)Text function

b)Math function 

c)Date & Time 

d) Statistical function 

e) Logical function 

f)Database function 

Text function:

There are following used function in libre office. 

• Left: This function is used to display the specified numbers of characters from the left side of a text string. 

    =Left("karamraji",3) 

    =kar 

• Right:This function is used to display the specified numbers of characters from the right side of a text string.

    =right("kics", 2) 

    =CS 

• Upper:This function is used to convert all lower case in the text string to upper case. 

    =Upper("kics") 

    =KICS 

• Lower:This function is used to convert all lower case in the text string to lower case. 

    = lower("KICS") 

    =kics 

• Mid: This function is used to display the specified numbers of characters from the middle of a text string,given a string position and length. 

     =mid("kics"2,2) 

     =ic 

• Len: This function is used to display the length of a text string, spaces are counted as character. 

      = len("kics")

      =4 

• Proper: This function is used to convert the first letters of each word in a text string to upper case just like title case and remaining letter to lower case.

      Exp:

      =Proper("kics")

     = Kics 

• Rept: Function is used to repeat the given text to a specified number of times.

      Exp:

      =rept("kics",3)

      =kicskicskics 

• Find: Karamraji 

    =find("m",f2)

    =5 

Math functions: 

• Sum: It is used to add the cell values or range of cells. 

      =sum(A1:D6) 

• Sumif: This function is used to sum the condition. 

     

      =sumif(B2:B6,25)                                       

     =75 

• Round: It is used for round the number to a specified number of digits. 

     =round(2634.26,-3)         OR      =round(2634.265,2)          OR       =round(2634,-2) 

     =3000                                       =2634.27                                    =2600

 

• Roundup: It rounds a number up, away from 0.

      =roundup (2345.5678,2)       OR         roundup (2345.5678,-3)         OR =roundup(2345.342,2) 

      =2345.57                                          =3000                                        =2345.35 

• Rounddown: It rounds a number down,towards 0.

     =rounddown(2345.5678,-2)        OR        =rounddown(2345.5678,2) 

    =2300                                                    =2345.56

• Square root: 

    =sqrt(value) 

    =(64)=8 

• Modulus division: 

     =mod(number,divisor) 

     =mod(5,2)=1 

• Product(): 

    =product(2,5)=10 

• Power(): 

    =power(base,exponent) 

    =power(2,3)=8 

    Exp: 4^2^3=16^3=4096

    OR 

    16/2^3=16/8=2 

• Trunc: It truncates a number to an integer by removing the decimal or fractional, part of the number.

              OR

           Truncate the decimal places number. 

           =trunc(5623.5657,2)

           =5623.56 

•  Average: 

      =average(A1:A5) 

• Even: It gives you even number.

      =even(5)        OR    =even(4)

      =6                          =4 

                                   

• Odd: It gives you odd number.

    =odd(6)         OR =odd(7) 

       = 7                                          = 7

  Exp: =even(2)+odd(2) 

          =5 

        OR 

      =even(-9)+odd(-10)=-21 

• Absolute: 

    =abs(-2)=2 

• Factorial: 

      =fact(3)=6 

• Floor: =floor(120,11)    or          =floor(-120,-11)   or = floor(- 120, 11)          

            =110                             =-121                                         = Error

• Ceiling: 

      =ceiling(120,11)     or         = ceiling(-120,-11) 

          =121                                                          =-110 

Statistical function: 

• Count: It is count to numeric value in the given range. It contain different data types but where only numbers are counted. 

     

           =count(A1:A3)=2    or =counta(B1:B3)

           =3                              =3 

• CountA: It calculate the number of cell where numeric & alphabetic value written in cell. 

     =counta(A1:A3)      or     =counta(B1:B3)

     =3                                  =3 

• Countif: The range of cells to be evaluated by the criteria given .

     =countif(A1:A4, ">4")=2 

• Minimum: This is used to gives the minimum value in the given range of cell. 

       =min(cell range) 

• Maximum:This is used to gives the maximum value in the given range of cell. 

       =max(cell range) 

 Date and time function: 

• Today: Display current date of the computer. 

      =today() 

• Now: Display current date and time of the computer. =now() 
• Weekday: This function is used to display the day of week corresponding data. 

      =weekday("4/5/2025") 

• Days360: This function is used to display the number of day between two days. 

     =days360("1/5/2025", "5/5/2025") 

Logical function: 

• If: It is used to find the result according to the condition. If condition is true it return '1' value and if condition is false it return '0' value. 

     =if(A2>300, "pass", "fail") 

     =Pass

• AND: It checks whether all arguments are true, and returns TRUE if all arguments are TRUE. 

     =AND(4>2,5<6, 4>3) 

     = TRUE 

• OR: It checks whether any arguments are true, and returns true or false only if all arguments are false. 

      =OR(4>2,5<6,2>2)

      =True 

6) Database functions: 

 DSUM 

DMIN 

DMAX 

DCOUNT 

DCOUNTA 

Some other functions are: 

Percentage(%)=  Total no. of marks / Total no. Of subject 

Grade = IF(H1>=90, "A", IF(H1>=80, "B", IF(H1>=70, "C", IF(H1>=60,"D", IF(H1<60, "F"))))) 

                  OR

         =IF(H1>=90, "A", IF(H1>=80, "B", IF(H1>=70, "C", IF(H1>=60,"D", "F" )))) 

Concatenate(): Text for concatenation.

= concatenate(A1,B1)