# 60 Useful Excel Formulas That Are Good To Know

60 useful excel formulas that are a good to know
DATE = Returns the serial number of a particular date
DATEVALUE = Converts a date in the form of text to a serial number
DAY = Converts a serial number to a day of the month
EOMONTH = Returns the serial number of the last day of the month before or after a specified number of months
MONTH = Converts a serial number to a month
NOW = Returns the serial number of the current date and time
TODAY = Returns the serial number of today’s date
YEAR = Converts a serial number to a year
CLEAN = Removes all nonprintable characters from text
FIND = Finds one text value within another (case-sensitive)
LEFT = Returns the leftmost characters from a text value
LEN = Returns the number of characters in a text string
LOWER = Converts text to lowercase
MID = Returns a specific number of characters from a text string starting at the position you specify
REPLACE = Replaces characters within text
REPT = Repeats text a given number of times
RIGHT = Returns the rightmost characters from a text value
SUBSTITUTE = Substitutes new text for old text in a text string
UPPER = Converts text to uppercase
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
LARGE = Returns the k-th largest value in a data set
MAX = Returns the maximum value in a list of arguments
MEDIAN = Returns the median of the given numbers
MIN = Returns the minimum value in a list of arguments
MODE = Returns the most common value in a data set
PERCENTILE = Returns the k-th percentile of values in a range
RANK = Returns the rank of a number in a list of numbers
SMALL = Returns the k-th smallest value in a data set
STDEV = Estimates standard deviation based on a sample
AND = Returns TRUE if all its arguments are TRUE
FALSE = Returns the logical value FALSE
IF = Specifies a logical test to perform
NOT = Reverses the logic of its argument
OR = Returns TRUE if any argument is TRUE
TRUE = Returns the logical value TRUE
LOG = Returns the logarithm of a number to a specified base
MOD = Returns the remainder from division
RANDBETWEEN = Returns a random number between the numbers you specify
ROUNDDOWN = Rounds a number down, toward zero
ROUNDUP = Rounds a number up, away from zero
SUMIF = Adds the cells specified by a given criteria
FV = Returns the future value of an investment
IRR = Returns the internal rate of return for a series of cash flows
NPV = Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
PMT = Returns the periodic payment for an annuity
PV = Returns the present value of an investment
ADDRESS = Returns a reference as text to a single cell in a worksheet
HLOOKUP = Looks in the top row of an array and returns the value of the indicated cell
INDEX = Uses an index to choose a value from a reference or array
INDIRECT = Returns a reference indicated by a text value
LOOKUP = Looks up values in a vector or array
MATCH = Looks up values in a reference or array
OFFSET = Returns a reference offset from a given reference
ROW = Returns the row number of a reference
VLOOKUP = Looks in the first column of an array and moves across the row to return the value of a cell
GETPIVOTDATA = Returns data stored in a PivotTable
ISBLANK = Returns TRUE if the value is blank
ISERROR = Returns TRUE if the value is any error value ## 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=""> <s> <strike> <strong> 