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
SUM = Adds its arguments
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

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=""> <s> <strike> <strong>

Comments and Trackbacks

  1. Bill Herschede wrote:

    I have a question. Is there an excel formula that can calculate the 1st of the month following the previous 60 days. Our emplyees qualify for health benefits the first of the month following 60 days employment and i would like to put that in a spread sheet.
    Can you help me?


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


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel