20 Useful Excel Formulas You Must Know




TumblrStumbleUponRedditLinkedInAIMDiggEvernoteWhatsAppMySpaceKindle It

20 Excel formulas you should know
DATEVALUE = Converts a date in the form of text to a serial number
DAY = Converts a serial number to a day of the month
MONTH = Converts a serial number to a month
YEAR = Converts a serial number to a year
LEFT = Returns the leftmost characters from a text value
LEN = Returns the number of characters in a text string
RIGHT = Returns the rightmost characters from a text value
AVERAGE = Returns the average of its arguments
COUNT = Counts how many numbers are in the list of arguments
COUNTIF = Counts the number of nonblank cells within a range that meet the given criteria
MAX = Returns the maximum value in a list of arguments
AND = Returns TRUE if all its arguments are TRUE
IF = Specifies a logical test to perform
ROUNDDOWN = Rounds a number down, toward zero
ROUNDUP = Rounds a number up, away from zero
SUM = Adds its arguments
SUMIF = Adds the cells specified by a given criteria
OFFSET = Returns a reference offset from a given reference
VLOOKUP = Looks in the first column of an array and moves across the row to return the value of a cell
ISERROR = Returns TRUE if the value is any error value

TumblrStumbleUponRedditLinkedInAIMDiggEvernoteWhatsAppMySpaceKindle It

Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?


XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagDutch flagHindi flagPolish flagSwedish flagFilipino flagHebrew flagIndonesian flagUkrainian flagThai flagTurkish flag
treeemap software for excel