# Excel functions list

> Every common Excel function explained in plain English, with live examples, common mistakes and a graded exercise for each.

Source: https://spreadsheetpractice.com/functions · Updated October 29, 2026

## Lookup functions

- [COLUMN](https://spreadsheetpractice.com/functions/column): COLUMN returns the column number of a cell: COLUMN(D1) is 4, and COLUMN() with nothing inside returns the column of the formula's own cell.
- [COLUMNS](https://spreadsheetpractice.com/functions/columns): COLUMNS counts how many columns a range or array has, whether or not the cells contain anything.
- [HLOOKUP](https://spreadsheetpractice.com/functions/hlookup): HLOOKUP is VLOOKUP turned sideways: it searches the top row of a table for a value and returns a value from a row below it, in the same column.
- [INDEX](https://spreadsheetpractice.com/functions/index): INDEX returns the value at a given row and column of a range: INDEX(A2:C10,4,2) is the fourth row, second column.
- [INDIRECT](https://spreadsheetpractice.com/functions/indirect): INDIRECT turns text into a reference: "B3" becomes the cell B3, and "A2:A"&D1 becomes a range whose last row comes from a cell.
- [LOOKUP](https://spreadsheetpractice.com/functions/lookup): LOOKUP finds a value in a sorted row or column and returns the value in the same position of another row or column.
- [MATCH](https://spreadsheetpractice.com/functions/match): MATCH returns the position of a value in a row or column: 3 means the third cell.
- [OFFSET](https://spreadsheetpractice.com/functions/offset): OFFSET returns a reference that starts a given number of rows and columns away from a starting cell, optionally resized to a new height and width.
- [ROW](https://spreadsheetpractice.com/functions/row): ROW returns the row number of a cell: ROW(C7) is 7, and ROW() with nothing inside returns the row of the cell the formula sits in.
- [ROWS](https://spreadsheetpractice.com/functions/rows): ROWS counts how many rows a range or array has, whether or not the cells contain anything.
- [VLOOKUP](https://spreadsheetpractice.com/functions/vlookup): VLOOKUP looks for a value in the first column of a table and returns a value from another column in the same row.
- [XLOOKUP](https://spreadsheetpractice.com/functions/xlookup): XLOOKUP searches one column or row for a value and returns the matching item from another.
- [XMATCH](https://spreadsheetpractice.com/functions/xmatch): XMATCH is the modern MATCH: it returns the position of a value in a list, but it defaults to an exact match, can search from the bottom up, and handles wildcards and next-larger or next-smaller matches without sorted data.

## Logical functions

- [AND](https://spreadsheetpractice.com/functions/and): AND returns TRUE only when every condition you give it is TRUE.
- [CHOOSE](https://spreadsheetpractice.com/functions/choose): CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.
- [IFERROR](https://spreadsheetpractice.com/functions/iferror): IFERROR returns a value you choose when a formula results in an error, and the formula's normal result otherwise.
- [IFNA](https://spreadsheetpractice.com/functions/ifna): IFNA returns a fallback only when a formula results in #N/A, the error lookups give when a value is missing.
- [IFS](https://spreadsheetpractice.com/functions/ifs): IFS checks a list of conditions in order and returns the value paired with the first one that is TRUE.
- [LET](https://spreadsheetpractice.com/functions/let): LET gives names to values or calculations inside a single formula, then uses those names in a final calculation.
- [NOT](https://spreadsheetpractice.com/functions/not): NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE.
- [OR](https://spreadsheetpractice.com/functions/or): OR returns TRUE when at least one of its conditions is TRUE.
- [SWITCH](https://spreadsheetpractice.com/functions/switch): SWITCH compares one value against a list of exact matches and returns the result paired with the first match, with an optional default at the end.
- [XOR](https://spreadsheetpractice.com/functions/xor): XOR returns TRUE when an odd number of its conditions are TRUE.

## Conditional sum and count functions

- [AVERAGEIF](https://spreadsheetpractice.com/functions/averageif): AVERAGEIF averages only the values that meet one condition: the average order from one region, response times for chat tickets, scores above zero.
- [AVERAGEIFS](https://spreadsheetpractice.com/functions/averageifs): AVERAGEIFS averages the values where every condition is true, such as Algebra scores from the fall term or passing scores only.
- [COUNTIF](https://spreadsheetpractice.com/functions/countif): COUNTIF counts the cells in a range that meet one condition: tickets marked "Open", scores of 70 or more, product names containing "lamp".
- [COUNTIFS](https://spreadsheetpractice.com/functions/countifs): COUNTIFS counts the rows where every condition is true: orders that are from the East region and shipped, deals between $500 and $1,000.
- [MAXIFS](https://spreadsheetpractice.com/functions/maxifs): MAXIFS returns the largest value among the rows that meet one or more conditions: the biggest deal in a region, the latest order date for a customer.
- [MINIFS](https://spreadsheetpractice.com/functions/minifs): MINIFS returns the smallest value among the rows that meet one or more conditions: the cheapest quote for a part, the earliest due date in a project, the lowest score above zero.
- [SUMIF](https://spreadsheetpractice.com/functions/sumif): SUMIF adds up values for the rows that meet one condition: total travel expenses, revenue for one product, every invoice over $500.
- [SUMIFS](https://spreadsheetpractice.com/functions/sumifs): SUMIFS adds the values where every condition is true: East region widget sales, February revenue, large orders from one customer.

## Math functions

- [ABS](https://spreadsheetpractice.com/functions/abs): ABS returns a number without its sign, so -250 becomes 250 and 250 stays 250.
- [AGGREGATE](https://spreadsheetpractice.com/functions/aggregate): AGGREGATE runs one of 19 calculations, from SUM and AVERAGE to LARGE and PERCENTILE, and can skip error values, hidden rows and other subtotals while it does.
- [CEILING](https://spreadsheetpractice.com/functions/ceiling): CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour.
- [EXP](https://spreadsheetpractice.com/functions/exp): EXP returns e (about 2.71828) raised to a power.
- [FLOOR](https://spreadsheetpractice.com/functions/floor): FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band.
- [INT](https://spreadsheetpractice.com/functions/int): INT rounds a number down to the nearest whole number.
- [LN](https://spreadsheetpractice.com/functions/ln): LN returns the natural logarithm of a number: the power you would raise e to in order to get it.
- [LOG](https://spreadsheetpractice.com/functions/log): LOG returns the logarithm of a number in the base you choose: the power the base must be raised to in order to reach the number.
- [LOG10](https://spreadsheetpractice.com/functions/log10): LOG10 returns the base-10 logarithm of a number: how many times 10 is multiplied to reach it.
- [MOD](https://spreadsheetpractice.com/functions/mod): MOD returns the remainder after dividing one number by another.
- [MROUND](https://spreadsheetpractice.com/functions/mround): MROUND rounds a number to the nearest multiple of another number.
- [PI](https://spreadsheetpractice.com/functions/pi): PI returns the constant π, accurate to 15 digits (3.14159265358979).
- [POWER](https://spreadsheetpractice.com/functions/power): POWER raises a number to a power, the same as the ^ operator.
- [PRODUCT](https://spreadsheetpractice.com/functions/product): PRODUCT multiplies all of its arguments together.
- [QUOTIENT](https://spreadsheetpractice.com/functions/quotient): QUOTIENT divides one number by another and returns only the whole-number part, dropping the remainder.
- [ROUND](https://spreadsheetpractice.com/functions/round): ROUND rounds a number to the number of digits you choose.
- [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown): ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- [ROUNDUP](https://spreadsheetpractice.com/functions/roundup): ROUNDUP always rounds away from zero, whatever the next digit is.
- [SIGN](https://spreadsheetpractice.com/functions/sign): SIGN tells you which side of zero a number is on: 1 for positive, -1 for negative and 0 for zero.
- [SQRT](https://spreadsheetpractice.com/functions/sqrt): SQRT returns the square root of a number: the value that, multiplied by itself, gives the number.
- [SUBTOTAL](https://spreadsheetpractice.com/functions/subtotal): SUBTOTAL calculates a sum, average, count or other total for a range while skipping any other SUBTOTAL formulas inside it, so section subtotals and a grand total never double count.
- [SUM](https://spreadsheetpractice.com/functions/sum): SUM adds numbers.
- [SUMPRODUCT](https://spreadsheetpractice.com/functions/sumproduct): SUMPRODUCT multiplies matching items in two or more ranges and adds the results.
- [SUMSQ](https://spreadsheetpractice.com/functions/sumsq): SUMSQ squares each number and adds the squares.
- [TRUNC](https://spreadsheetpractice.com/functions/trunc): TRUNC cuts a number off at a set number of decimals without rounding.

## Statistical functions

- [AVERAGE](https://spreadsheetpractice.com/functions/average): AVERAGE adds up the numbers you give it and divides by how many numbers there are.
- [COUNT](https://spreadsheetpractice.com/functions/count): COUNT tells you how many cells contain numbers.
- [COUNTA](https://spreadsheetpractice.com/functions/counta): COUNTA counts every cell that isn't empty: text, numbers, dates, errors and even formulas that return empty text.
- [COUNTBLANK](https://spreadsheetpractice.com/functions/countblank): COUNTBLANK counts the empty cells in a range: unassigned tasks, unanswered questions, missing dates.
- [LARGE](https://spreadsheetpractice.com/functions/large): LARGE returns the k-th largest value in a range: k = 1 is the largest, 2 the second largest, and so on.
- [MAX](https://spreadsheetpractice.com/functions/max): MAX returns the largest number from a list of values or ranges: the top sale, the latest date, the highest temperature.
- [MEDIAN](https://spreadsheetpractice.com/functions/median): MEDIAN returns the middle value once the numbers are sorted.
- [MIN](https://spreadsheetpractice.com/functions/min): MIN returns the smallest number from a list of values or ranges.
- [MODE](https://spreadsheetpractice.com/functions/mode): MODE returns the number that appears most often in a list, such as the most common shoe size or order quantity.
- [PERCENTILE.EXC](https://spreadsheetpractice.com/functions/percentile-exc): PERCENTILE.EXC returns the value at a given percentile using the exclusive method, which leaves out the very bottom and top of the range: k must sit strictly between 0 and 1, and close to the ends of a short list it returns #NUM!.
- [PERCENTILE.INC](https://spreadsheetpractice.com/functions/percentile-inc): PERCENTILE.INC returns the value below which a given share of the data falls: k = 0.9 gives the 90th percentile.
- [PERCENTRANK.INC](https://spreadsheetpractice.com/functions/percentrank-inc): PERCENTRANK.INC tells you where a value stands in a list, from 0 for the lowest to 1 for the highest: 0.75 means it is above 75% of the other values.
- [QUARTILE.EXC](https://spreadsheetpractice.com/functions/quartile-exc): QUARTILE.EXC returns the first, second or third quartile using the exclusive method, which some statistics tools and textbooks use.
- [QUARTILE.INC](https://spreadsheetpractice.com/functions/quartile-inc): QUARTILE.INC returns a quartile of a set of numbers: 1 for the first quartile (the 25th percentile), 2 for the median, 3 for the third quartile, and 0 and 4 for the minimum and maximum.
- [RANK.EQ](https://spreadsheetpractice.com/functions/rank-eq): RANK.EQ tells you where a number places within a list: 1 for the largest by default, or 1 for the smallest if you set the order to 1.
- [SMALL](https://spreadsheetpractice.com/functions/small): SMALL returns the k-th smallest value in a range: k = 1 is the smallest, 2 the second smallest, and so on.
- [STDEV](https://spreadsheetpractice.com/functions/stdev): STDEV measures how spread out a set of numbers is, treating them as a sample of a larger group.
- [STDEV.P](https://spreadsheetpractice.com/functions/stdev-p): STDEV.P measures how spread out a set of numbers is when those numbers are the entire population: every employee, every shift, every student in the class.
- [VAR](https://spreadsheetpractice.com/functions/var): VAR returns the variance of a sample: the average squared distance of each value from the mean.

## Text functions

- [CHAR](https://spreadsheetpractice.com/functions/char): CHAR returns the character for a code number.
- [CLEAN](https://spreadsheetpractice.com/functions/clean): CLEAN removes non-printing characters, such as line breaks and tabs, from text.
- [CODE](https://spreadsheetpractice.com/functions/code): CODE returns the numeric code of the first character in a text string.
- [CONCAT](https://spreadsheetpractice.com/functions/concat): CONCAT joins text from several cells or whole ranges into one string.
- [CONCATENATE](https://spreadsheetpractice.com/functions/concatenate): CONCATENATE joins up to 255 text items into one string.
- [EXACT](https://spreadsheetpractice.com/functions/exact): EXACT compares two text values and returns TRUE only if they match exactly, including upper and lower case.
- [FIND](https://spreadsheetpractice.com/functions/find): FIND returns the position of one piece of text inside another, counting from 1.
- [LEFT](https://spreadsheetpractice.com/functions/left): LEFT returns a set number of characters from the start of a text string.
- [LEN](https://spreadsheetpractice.com/functions/len): LEN counts the characters in a text string, including spaces and punctuation.
- [LOWER](https://spreadsheetpractice.com/functions/lower): LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone.
- [MID](https://spreadsheetpractice.com/functions/mid): MID returns characters from the middle of a text string, starting at a position you choose.
- [NUMBERVALUE](https://spreadsheetpractice.com/functions/numbervalue): NUMBERVALUE converts text that looks like a number into a real number, using the decimal and thousands separators you name rather than your computer's settings.
- [PROPER](https://spreadsheetpractice.com/functions/proper): PROPER capitalizes the first letter of each word and lowercases the rest.
- [REGEXEXTRACT](https://spreadsheetpractice.com/functions/regexextract): REGEXEXTRACT pulls out the part of a text that matches a regular expression: an order number, an email domain, the digits in a messy code.
- [REGEXREPLACE](https://spreadsheetpractice.com/functions/regexreplace): REGEXREPLACE replaces the parts of a text that match a regular expression.
- [REGEXTEST](https://spreadsheetpractice.com/functions/regextest): REGEXTEST checks whether text contains a match for a regular expression and returns TRUE or FALSE.
- [REPLACE](https://spreadsheetpractice.com/functions/replace): REPLACE swaps out a set number of characters at a given position, whatever those characters are.
- [REPT](https://spreadsheetpractice.com/functions/rept): REPT repeats a piece of text a given number of times.
- [RIGHT](https://spreadsheetpractice.com/functions/right): RIGHT returns a set number of characters from the end of a text string.
- [SEARCH](https://spreadsheetpractice.com/functions/search): SEARCH returns the position of one piece of text inside another, ignoring upper and lower case, and it understands the ? and * wildcards.
- [SUBSTITUTE](https://spreadsheetpractice.com/functions/substitute): SUBSTITUTE replaces specific text with new text everywhere it appears, or only at the occurrence you choose.
- [TEXT](https://spreadsheetpractice.com/functions/text): TEXT turns a number or date into text in the format you choose, such as "$1,250.00" or "March 2026".
- [TEXTAFTER](https://spreadsheetpractice.com/functions/textafter): TEXTAFTER returns everything after a delimiter, such as the domain after the @ or the last part of a file path.
- [TEXTBEFORE](https://spreadsheetpractice.com/functions/textbefore): TEXTBEFORE returns everything before a delimiter you name, such as the username before the @ in an email or the first name before a space.
- [TEXTJOIN](https://spreadsheetpractice.com/functions/textjoin): TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks.
- [TEXTSPLIT](https://spreadsheetpractice.com/functions/textsplit): TEXTSPLIT splits text into separate cells at a delimiter: across columns, down rows, or both.
- [TRIM](https://spreadsheetpractice.com/functions/trim): TRIM removes spaces from the start and end of text and shrinks runs of spaces between words to one.
- [UPPER](https://spreadsheetpractice.com/functions/upper): UPPER converts every letter in a text string to capitals.
- [VALUE](https://spreadsheetpractice.com/functions/value): VALUE converts text that looks like a number into a real number Excel can add, average and compare.

## Date functions

- [DATE](https://spreadsheetpractice.com/functions/date): DATE builds a real date from a year, month and day.
- [DATEDIF](https://spreadsheetpractice.com/functions/datedif): DATEDIF counts the complete years, months or days between two dates.
- [DATEVALUE](https://spreadsheetpractice.com/functions/datevalue): DATEVALUE converts a date that is stored as text into a real date that Excel can sort, subtract and format.
- [DAY](https://spreadsheetpractice.com/functions/day): DAY returns the day of the month from a date, as a number from 1 to 31.
- [DAYS](https://spreadsheetpractice.com/functions/days): DAYS returns the number of days between two dates.
- [EDATE](https://spreadsheetpractice.com/functions/edate): EDATE returns the date a given number of months before or after a start date, keeping the same day of the month.
- [EOMONTH](https://spreadsheetpractice.com/functions/eomonth): EOMONTH returns the last day of the month a number of months before or after a date.
- [HOUR](https://spreadsheetpractice.com/functions/hour): HOUR returns the hour of a time as a number from 0 to 23, so 1:45 PM gives 13.
- [ISOWEEKNUM](https://spreadsheetpractice.com/functions/isoweeknum): ISOWEEKNUM returns the ISO 8601 week number of a date: weeks start on Monday, and week 1 is the week that contains the year's first Thursday.
- [MINUTE](https://spreadsheetpractice.com/functions/minute): MINUTE returns the minutes part of a time as a number from 0 to 59, so 1:45 PM gives 45.
- [MONTH](https://spreadsheetpractice.com/functions/month): MONTH returns the month of a date as a number from 1 to 12.
- [NETWORKDAYS](https://spreadsheetpractice.com/functions/networkdays): NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date.
- [NETWORKDAYS.INTL](https://spreadsheetpractice.com/functions/networkdays-intl): NETWORKDAYS.INTL counts the working days between two dates, like NETWORKDAYS, but lets you say which days are the weekend: Friday and Saturday, Sunday only, or any pattern written as a seven-character string such as "0000011".
- [NOW](https://spreadsheetpractice.com/functions/now): NOW returns the current date and time, and updates whenever the workbook recalculates.
- [SECOND](https://spreadsheetpractice.com/functions/second): SECOND returns the seconds part of a time as a number from 0 to 59.
- [TIME](https://spreadsheetpractice.com/functions/time): TIME builds a time from hours, minutes and seconds, such as TIME(13,30,0) for 1:30 PM.
- [TIMEVALUE](https://spreadsheetpractice.com/functions/timevalue): TIMEVALUE converts a time written as text, such as "1:30 PM" or "13:30", into a real time you can add, subtract and format.
- [TODAY](https://spreadsheetpractice.com/functions/today): TODAY returns the current date, with no time attached, and updates every time the workbook recalculates.
- [WEEKDAY](https://spreadsheetpractice.com/functions/weekday): WEEKDAY returns the day of the week for a date as a number.
- [WEEKNUM](https://spreadsheetpractice.com/functions/weeknum): WEEKNUM returns the week number of a date in its year, 1 to 54.
- [WORKDAY](https://spreadsheetpractice.com/functions/workday): WORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list.
- [WORKDAY.INTL](https://spreadsheetpractice.com/functions/workday-intl): WORKDAY.INTL returns the date a number of working days before or after a start date, skipping the weekend days you choose and any holidays.
- [YEAR](https://spreadsheetpractice.com/functions/year): YEAR returns the four-digit year from a date.
- [YEARFRAC](https://spreadsheetpractice.com/functions/yearfrac): YEARFRAC returns the fraction of a year between two dates, such as 0.5 for six months.

## Dynamic array functions

- [BYCOL](https://spreadsheetpractice.com/functions/bycol): BYCOL runs a LAMBDA on each column of a range and returns one result per column, in a single formula that spills across.
- [BYROW](https://spreadsheetpractice.com/functions/byrow): BYROW runs a LAMBDA on each row of a range and returns one result per row, all from one spilling formula.
- [CHOOSECOLS](https://spreadsheetpractice.com/functions/choosecols): CHOOSECOLS returns only the columns you name from a range or array, in the order you name them, so 3,1 puts the third column first.
- [CHOOSEROWS](https://spreadsheetpractice.com/functions/chooserows): CHOOSEROWS returns the rows you name from a range or array: 1 is the first row and -1 the last, so CHOOSEROWS(range,-1) always gives the latest entry.
- [DROP](https://spreadsheetpractice.com/functions/drop): DROP removes rows or columns from the start or end of a range and returns what is left.
- [FILTER](https://spreadsheetpractice.com/functions/filter): FILTER returns only the rows of a range that pass a test, such as every order from the West region.
- [HSTACK](https://spreadsheetpractice.com/functions/hstack): HSTACK places ranges side by side to build one table, so you can pick columns that aren't next to each other, put them in a new order, or add a calculated column, all in one formula that updates with the source.
- [LAMBDA](https://spreadsheetpractice.com/functions/lambda): LAMBDA creates your own function from a formula: name the inputs, then write the calculation, as in LAMBDA(price, rate, price*(1+rate)).
- [MAKEARRAY](https://spreadsheetpractice.com/functions/makearray): MAKEARRAY builds an array of a given number of rows and columns by calling a LAMBDA with each row and column number.
- [MAP](https://spreadsheetpractice.com/functions/map): MAP runs a LAMBDA on each value of an array, or on matching values from several arrays, and returns an array of the same size.
- [REDUCE](https://spreadsheetpractice.com/functions/reduce): REDUCE walks through every value in an array, passing a running result and the next value to a LAMBDA, and returns the final running result.
- [SCAN](https://spreadsheetpractice.com/functions/scan): SCAN works like REDUCE, passing a running result and each value to a LAMBDA, but it returns the running result at every step instead of just the last one.
- [SEQUENCE](https://spreadsheetpractice.com/functions/sequence): SEQUENCE generates a list or grid of numbers from one formula: 1 to 10, every fifth number, or a countdown.
- [SORT](https://spreadsheetpractice.com/functions/sort): SORT returns a sorted copy of a range, ordered by any column you choose, smallest to largest or the reverse.
- [SORTBY](https://spreadsheetpractice.com/functions/sortby): SORTBY sorts one range by the values in another.
- [TAKE](https://spreadsheetpractice.com/functions/take): TAKE keeps the first or last rows (and columns) of a range and drops the rest.
- [TOCOL](https://spreadsheetpractice.com/functions/tocol): TOCOL turns a range or array into a single column, reading across each row unless you ask for column by column.
- [TOROW](https://spreadsheetpractice.com/functions/torow): TOROW turns a range or array into a single row, reading across each row unless you ask for column by column.
- [TRANSPOSE](https://spreadsheetpractice.com/functions/transpose): TRANSPOSE flips a range so rows become columns and columns become rows.
- [UNIQUE](https://spreadsheetpractice.com/functions/unique): UNIQUE returns each distinct value in a range once, in the order it first appears.
- [VSTACK](https://spreadsheetpractice.com/functions/vstack): VSTACK stacks ranges on top of each other into one list, such as this month's orders under last month's or one region's reps under another's.

## Financial functions

- [FV](https://spreadsheetpractice.com/functions/fv): FV calculates what an investment will be worth in the future, given regular deposits, a starting balance and a constant rate of return.
- [IRR](https://spreadsheetpractice.com/functions/irr): IRR calculates the internal rate of return: the discount rate at which a series of cash flows has a net present value of zero.
- [NPER](https://spreadsheetpractice.com/functions/nper): NPER calculates how many payment periods it takes to pay off a loan or reach a savings goal, at a fixed payment and interest rate.
- [NPV](https://spreadsheetpractice.com/functions/npv): NPV discounts a series of future cash flows back to today at a given rate, so you can judge whether an investment beats your cost of capital.
- [PMT](https://spreadsheetpractice.com/functions/pmt): PMT calculates the fixed payment for a loan or a savings plan, based on a constant interest rate and number of payments.
- [PV](https://spreadsheetpractice.com/functions/pv): PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate.
- [RATE](https://spreadsheetpractice.com/functions/rate): RATE works out the interest rate per period from the number of payments, the payment and the amount borrowed or invested.

## Information functions

- [ISBLANK](https://spreadsheetpractice.com/functions/isblank): ISBLANK returns TRUE when a cell is completely empty.
- [ISERR](https://spreadsheetpractice.com/functions/iserr): ISERR returns TRUE for any error except #N/A.
- [ISERROR](https://spreadsheetpractice.com/functions/iserror): ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?.
- [ISEVEN](https://spreadsheetpractice.com/functions/iseven): ISEVEN returns TRUE when a number is even.
- [ISLOGICAL](https://spreadsheetpractice.com/functions/islogical): ISLOGICAL returns TRUE when a value is one of the logical values, TRUE or FALSE.
- [ISNA](https://spreadsheetpractice.com/functions/isna): ISNA returns TRUE only for the #N/A error, the one MATCH, VLOOKUP and XLOOKUP return when a value isn't found.
- [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber): ISNUMBER returns TRUE when a value is a real number, which includes dates and times.
- [ISODD](https://spreadsheetpractice.com/functions/isodd): ISODD returns TRUE when a number is odd.
- [ISTEXT](https://spreadsheetpractice.com/functions/istext): ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return.
- [NA](https://spreadsheetpractice.com/functions/na): NA() returns the #N/A error on purpose, to mark a value as not available.

## Comparisons

- [VLOOKUP vs XLOOKUP](https://spreadsheetpractice.com/functions/compare/vlookup-vs-xlookup)
- [XLOOKUP vs INDEX and MATCH](https://spreadsheetpractice.com/functions/compare/xlookup-vs-index-match)
- [COUNTIF vs COUNTIFS](https://spreadsheetpractice.com/functions/compare/countif-vs-countifs)
- [SUMIF vs SUMIFS](https://spreadsheetpractice.com/functions/compare/sumif-vs-sumifs)
- [FIND vs SEARCH](https://spreadsheetpractice.com/functions/compare/find-vs-search)
- [IFERROR vs IFNA](https://spreadsheetpractice.com/functions/compare/iferror-vs-ifna)
- [CONCAT vs TEXTJOIN vs &](https://spreadsheetpractice.com/functions/compare/concat-vs-textjoin)
- [ROUND vs ROUNDUP vs ROUNDDOWN](https://spreadsheetpractice.com/functions/compare/round-vs-roundup-vs-rounddown)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
