# Excel function

40 %
60 %
Education

Published on March 10, 2014

Author: SirajRock

Source: slideshare.net

## Description

SirajRock

Math function =sum(n1,n2……..) Sum function return total of given number or ref. Exam =sum(4,5,2) 11 =product(n1,n2,n3…….) Product function return multiplication of given number or ref =product(5,4,2) (5*4*2=40) 40 =min(n1,n2,n3…) Minimum function return mini number from given number or ref =min(4,5,6,2) 2 =max(n1,n2,n3…….) max function return maximum number from given Number or ref =count() count function count numerical cell =counta() countall function count all cell from given ref. =countblank() function count blank cell =average(n1,n2,n3……) average function return average of given num =average(4,5,6) 5 =ceiling(number, significant) =ceiling(123,10) 130 =floor(number, significant) =floor(123,10) 120 =round(number, significant) =round(123.256,2) 123.26 =roundup(number, significant) =round(123.256,2) 123.26 =rounddown(number, significant) =round(123.256,2) 123.26 =int(number) int function return integar value from given numer =int(145.20) 145 =mod(number , divisor) rock_siraj@ymail.com

=mod(10,3) 1 Mod function return reminder =power(number , power) =power(5,3) power function return power of given number and power 125 (5*5*5) =fact(number) Fact function return factorial of given number =fact(5) 120 (5*4*3*2*1) =rand() rand function return random number =randbetween(min number, max number) Rand between function return randomly number between given Min and maximum number =rank(number, rang) Rank function return rank of given number from given rang =sort(number) Return square root of given number =sQrt(25) 5 rock_siraj@ymail.com Text function =upper(“string “) upper function convert all letter in capital letter =upper(“lion”) LION =lower(“String”) lower function convert all letter in small letter =lower(“LIOn”) lion =proper(“this is a book”) Proper function convert capital letter of each word of given string =proper(“this is a book”) This Is A Book =len(“string”) Len function count char of given string =len(“lion”) 4 =left(string, number) Left function return particular number of char from the left side =left(“ram”,2) ra =right(“string”,number)

Right function return particular number of char from right side =right(“ram”,2) am =trim(“string”) Remove space from left and right side of string, =concatenate(“string1”,”string 2”……………..) Concatenate function concatenate given multiple string oncatenate Operator is also aviable in excel (&) =rept(“string”,”number of times) rept function repeat given string no of times =rept(“lion”,3) lionlionlion =value(text) value function convert string number in numerical number =text(number) text number convert numerical number in string number rock_siraj@ymail.com =code(“char”) code function return ascii code of given number =char(ascii code) function return char of given ascii code =replace() Date and time Date formate depand on o.s ( o.s default fomat is mm/dd/yyyy)

=and(con1,con2,……) And function return ture if given all condition are true =or(con1,con2,con3………………. .) Or function return false if given all condition are false =not(condition) Not function convert condition result. If condition is ture it return false. If Condition is false it return true =countif(range,condition) countif function count cell according to given Condition =iferror(error,”massage”) if error function return given massage if any error =sumif(range,condition) Sumif function return total of given range according to condition rock_siraj@ymail.com .

 User name: Comment:

## Related presentations

#### TED Talk

September 20, 2017

#### 7 Proven Ways To Lose Weight Fast

September 20, 2017

#### Tutorial for oracle 11g

September 20, 2017

September 20, 2017

#### Online Management Skills Development Course

September 20, 2017

#### CRT course training institute Hyderabad

September 16, 2017

## Related pages

### Excel functions (by category) - Office Support

Lists all Excel functions by their category, such as Logical functions or Text functions.

### Excel Functions - EASY Excel Tutorial

Discover how functions in Excel help you save time. If you are new to functions in Excel, we recommend you to read our introduction to formulas and ...

### VBA in Excel/ Funktionen - de.wikibooks.org

Verwendung im Arbeitsblatt . Sie haben die Möglichkeit, Excel-Funktionen oder deren Ergebnisse in einem Arbeitsblatt eintragen zu lassen. Sinnvollerweise ...

### Excel Functions and Formulas

Provides help to users of Excel, with an emphasis on functions and formulas, but also covering basic Excel, tips and an introduction to VBA.

### MS Excel: Formulas and Functions - Listed by Category

Learn how to use all 300+ Excel formulas and functions including worksheet functions entered in the formula bar and VBA functions used in Macros. Here are ...

### Excel: Funktion erstellen - CHIP

Eigene Funktion in Excel erstellen. Funktion in Excel erstellen. Öffnen Sie im ersten Schritt Excel, falls noch nicht geschehen. Klicken Sie in der ...

### MS Excel : How to use the AND Function (WS)

This Excel tutorial explains how to use the Excel AND function with syntax and examples. The Microsoft Excel AND function returns TRUE if all conditions ...

### Excel - Funktionen - iti.fh-flensburg.de

Excel bietet eine sehr große Anzahl von Funktionen. Es gibt mathematische Funktionen, Datums­funktionen, statistische Funktionen, Textfunktionen und andere.