Excel function

38 %
62 %
Information about Excel function
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 .

Add a comment

Related presentations

Related pages

Excel functions (by category) - Office Support

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

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 ...
Read more

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 ...
Read more

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.
Read more

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 ...
Read more

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 ...
Read more

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 ...
Read more

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.
Read more

Excel Funktionen - edv-lehrgang.de

Neben der der Runden-Funktion sind zwei weitere Funktionen vorhanden, AUFRUNDEN und ABRUNDEN. In den vorherigen Excel-Versionen musste diese Möglichkeit ...
Read more

VERWEIS (Funktion) - Office-Support

Gilt für: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 für Mac, Excel für Mac 2011, Excel Online, Excel Starter, Weniger
Read more