Excel Functions for the Minimalist

Yes, sometimes less is more. Required arguments in dark gray, optional arguments in white.

Date and time

DATE
Create a valid date from year, month, and day
yearmonthday
DATEVALUE
Convert a date in text format to a valid date
date_text
DAY
Get the day as a number (1-31) from a date
date
DAYS360
Get days between 2 dates in a 360-day year
start_datestart_datemethod
EDATE
Get the same date in future or past months
start_datemonths
EOMONTH
Get the last day of the month in future or past months
start_datemonths
HOUR
Get the hour as a number (0-23) from a Time
serial_number
MINUTE
Get the minute as a number (0-59) from a time
serial_number
MONTH
Get the month as a number (1-12) from a date
date
NETWORKDAYS
Get the number of working days between two dates
start_dateend_dateholidays
NOW
Get the current date and time
SECOND
Get the Second as a number (0-59) from a Time
serial_number
TIME
Create a time with hours, minutes, and seconds
hourminutesecond
TIMEVALUE
Get a valid time from a text string
time_text
TODAY
Get the current date
WEEKDAY
Get the day of the week as a number
serial_number return_type
WEEKNUM
Get the week number for a given date
serial_numreturn_type
WORKDAY
Get a date n working days in the future or past
start_datedaysholidays
YEAR
Get the year from a date
date
YEARFRAC
Get the fraction of a year between two dates
start_dateend_datebasis

Information

CELL
Get information about a cell
info_typereference
ERROR.TYPE
Test for a specific error value
error_val
ISBLANK
Test if a cell is blank
value
ISERR
Test for any error but #N/A
value
ISERROR
Test for any error
value
ISEVEN
Test if a value is even
value
ISLOGICAL
Test if a value is logical
value
ISNA
Test for the #N/A error
value
ISNONTEXT
Test for a non-text value
value
ISNUMBER
Test for numeric value
value
ISODD
Test if a value is odd
value
ISREF
Test for a reference
value
ISTEXT
Test for a text value
value
N
Convert a value to a number
value
NA
Create an #N/A error
TYPE
Get the type of value in a cell
value

Logical

AND
Test multiple conditions with AND
logical1logical2...
FALSE
Generate the logical value FALSE
IF
Test for a specific condition
logical_testvalue_if_truevalue_if_false
IFERROR
Trap and handle errors
valuevalue_if_error
NOT
Reverse arguments or results
logical
OR
Test multiple conditions with OR
logical1logical2...
TRUE
Generate the logical value TRUE

Lookup and reference

ADDRESS
Create a cell address from a given row and column
row_numcol_numabs_numa1sheet
AREAS
Get the number of areas in a reference.
reference
CHOOSE
Get a value from a list based on position
index_numvalue1value2...
COLUMN
Get the column number of a reference.
reference
COLUMNS
Get the number of columns in an array or reference.
array
HLOOKUP
Look up a value in a table by matching on the first row
valuetablerow_indexrange_lookup
HYPERLINK
Create a clickable link.
link_locationfriendly_name
INDEX
Get a value in a list or table based on location
arrayrow_numcol_numarea_num
INDIRECT
Create a reference from text
ref_texta1
LOOKUP
Look up a value in a one-column range
lookup_valuelookup_vectorresult_vector
MATCH
Get the position of an item in an array
lookup_valuelookup_arraymatch_type
OFFSET
Create a reference offset from given starting point
referencerowscolsheightwidth
ROW
Get the row number of a reference
reference
ROWS
Get the number of rows in an array or reference.
array
TRANSPOSE
Flip the orientation of a range of cells
array
VLOOKUP
Look up a value in a table by matching on the first column
valuetablecol_indexrange_lookup

Math

CEILING
Round a number up to the nearest specified multiple
numbermultiple
EVEN
Round a number up to the next even integer
number
FLOOR
Round a number down to the nearest specified multiple
numbermultiple
MROUND
Round a number to the nearest specified multiple
numbermultiple
ODD
Round a number up to the next odd integer
number
RAND
Get a random number between 0 and 1
RANDBETWEEN
Get a random integer between two values
bottomtop
ROUND
Round a number to a given number of digits
numbernum_digits
ROUNDDOWN
Round a number down to a given number of digits
numbernum_digits
ROUNDUP
Round a number up to a given number of digits
numbernum_digits
SUBTOTAL
Get a subtotal in a list or database
function_numref1ref2...
SUM
Add numbers together
number1number2number3...
SUMIF
Sum numbers in a range that meet supplied criteria
rangecriteriasum_range
SUMPRODUCT
Multiply, then sum arrays
array1array2...

Statistical

AVERAGE
Get the average of a group of numbers
number1number2...
AVERAGEA
Get the average of a group of numbers and text
value1value2...
AVERAGEIF
Get the average of numbers that meet criteria
rangecriteriaaverage_range
COUNT
Get the number of numbers
value1value2...
COUNTA
Count the number of non-blank cells
value1value2...
COUNTBLANK
Count cells that are blank
range
COUNTIF
Count cells that match criteria
rangecriteria
LARGE
Get the nth largest value
arrayn
MEDIAN
Get the median of a group of numbers
number1number2...
MODE
Get the mode of a group of numbers
number1number2...
RANK
Rank a number against a range of numbers
numberarrayorder
SMALL
Get the nth smallest value
arrayn

Text

CHAR
Get a character from a number
number
CLEAN
Strip non-printable characters from text
text
CODE
Get the code for a character
text
CONCATENATE
Join text together
text1text2text3...
DOLLAR
Convert a number to text in currency format
numberdecimals
EXACT
Compare two text strings
text1text2
FIND
Get the location of text in a string
find_text within_textstart_num
LEFT
Extract text from the left of a string
textnum_chars
LEN
Get the length of text.
text
LOWER
Convert text to lower case
text
MID
Extract text from inside a string
textstart_num num_chars
PROPER
Capitalize the first letter in each word
text
REPLACE
Replace text based on location
old_textstart_numnum_charsnew_text
REPT
Repeat text as specified
textnumber_times
RIGHT
Extract text from the right of a string
textnum_chars
SEARCH
Get the location of text in a string
find_text within_textstart_num
SUBSTITUTE
Replace text based on content
textold_textnew_textinstance
TEXT
Convert a number to text in a number format
valueformat_text
TRIM
Remove extra spaces from text
text
UPPER
Convert text to upper case
text
VALUE
Convert text to a number
text

Is this page useful to you? If so, can you please share it? We appreciate your help!