In this Excel Formulas Tutorial, we’ll share 102+ Excel formulas as a cheat sheet in a free PDF. You can download the PDF and print it to revise when needed. We did not include specialized formulas for Engineering, Statistics, Web, and other uses.

Provide a Valid Email ID below to download the PDF & Excel Files with 102 Excel Functions.

## 102 Most Useful Excel Formulas with Examples

### Section A – IS FUNCTIONS

#### 1. ISBLANK

=ISBLANK(value)

If a cell is blank, it returns TRUE. If a cell is not blank, it returns FALSE.

#### 2. ISERR

=ISERR(value)

Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSE.

#### 3. ISERROR

=ISERROR(value)

Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE.

#### 4. ISEVEN

=ISEVEN(value)

Returns TRUE if the number is even.

#### 5. ISODD

=ISODD(value)

Returns TRUE if the number is odd.

#### 6. ISFORMULA

=ISFORMULA(value)

Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE.

#### 7. ISLOGICAL

=ISLOGICAL(value)

Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.

#### 8. ISNA

=ISNA(value)

Checks whether a value is #N/A and returns TRUE or FALSE.

#### 9. ISNUMBER

=ISNUMBER(value)

Checks whether a value is a number, and returns TRUE or FALSE.

#### 10. ISREF

=ISREF(value)

Checks whether a value is a reference, and returns TRUE or FALSE.

#### 11. ISTEXT

=ISTEXT(value)

Checks whether a value is text, and returns TRUE or FALSE.

#### 12. ISNONTEXT

=ISNONTEXT(value)

Checks whether a value is not text (blank cells are not text) and returns TRUE or FALSE.

### Section B – CONDITIONAL FUNCTIONS

#### 13. AVERAGEIF

=AVERAGEIF(range, criteria, [average_range])

Finds the average (arithmetic mean) for the cells specified by a given condition or criteria.

#### 14. SUMIF

=SUMIF(range, criteria, [sum_range])

Adds the cells specified by a given condition or criteria.

#### 15. COUNTIF

=COUNTIF(range, criteria)

Counts the number of cells within a range that meet the given condition.

#### 16. AVERAGEIFS

=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Finds the average (arithmetic mean) for the cells specified by a given set of conditions or criteria.

#### 17. SUMIFS

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Adds the cells in the sum range if all corresponding cells in the criteria ranges fulfill their conditions.

#### 18. COUNTIFS

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

Counts the number of cells in multiple ranges if each corresponding cell fulfills its criteria.

#### 19. IF

=IF(logical_test, [value_if_true], [value_if_false]

Checks whether a condition is met, then returns one value if TRUE another value if FALSE.

#### 20. IFERROR

=IFERROR(value, value_if_error)

Returns the value_if_error if the expression is an error and the value of the expression itself otherwise.

#### 21. IFNA

=IFNA(value, value_if_na)

Returns the value you specify if the expression resolves to #N/A. Otherwise, returns the result of the expression.

### Section C – MATHEMATICAL FUNCTIONS

#### 22. SUM

=SUM(number1, [number2], [number3], [number4], …)

Adds all the numbers in a list or range of cells.

#### 23. AVERAGE

=AVERAGE(number1, [number2], [number3], [number4], …)

Returns the average (arithmetic means) of its arguments, which can be numbers or names, arrays, or references that contain numbers.

#### 24. AVERAGEA

=AVERAGEA(value1, [value2], [value3], [value4], …)

Returns the average (arithmetic means) of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1. Arguments can be numbers, names, arrays, or references.

#### 25. COUNT

=COUNT(value1, [value2], [value3], …)

Counts the number of cells in a range that contain numbers.

#### 26. COUNTA

=COUNTA(value1, [value2], [value3], …)

Counts the number of cells in a range that are not empty.

#### 27. MEDIAN

=MEDIAN(number1, [number2], [number3], …)

Returns the median, or the number in the middle of the set of given numbers.

#### 28. SUMPRODUCT

=SUMPRODUCT(array1, [array2], [array3], …)

Returns the sum of the products of corresponding ranges or arrays.

#### 29. SUMSQ

=SUMSQ(number1, [number2], [number3], …)

Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references to cells that contain numbers.

#### 30. COUNTBLANK

=COUNTBLANK(range)

Counts the number of empty cells in a range.

#### 31. EVEN

=EVEN(number)

Rounds a positive number up and negative number down to the nearest even integer.

#### 32. ODD

=ODD(number)

Rounds a positive number up and negative number down to the nearest odd integer.

#### 33. INT

=INT(number)

Rounds a number down to the nearest integer.

#### 34. LARGE

=LARGE(array, k)

Returns the k-th largest value in a data set. For example, k=5 returns the fifth-largest number.

#### 35. SMALL

=SMALL(array, k)

Returns the k-th smallest value in a data set. For example, k=5 returns the fifth smallest number.

#### 36. MAX and MAXA

=MAX(number1, [number2], [number3], [number4], …)

Returns the largest value in a set of values. Ignores logical values and text.

=MAXA(value1, [value2], [value3], [value4], …)

Returns the largest value in a set of values. Does not ignore logical values and text. MAXA function evaluates TRUE as 1, FALSE as 0, and any Text value as 0. Empty cells are ignored.

#### 37. MIN and MINA

=MIN(number1, [number2], [number3], [number4], …)

Returns the smallest number in a set of values. Ignores logical values and text.

=MINA(value1, [value2], [value3], [value4], …)

Returns the smallest value in a set of values. Does not ignore logical values and text. MAXA function evaluates TRUE as 1, FALSE as 0, and any Text value as 0. Empty cells are ignored.

#### 38. MOD

=MOD(number, divisor)

Returns the remainder after a number is divided by a divisor.

#### 39. RAND

=RAND()

Returns a random number greater than or equal to 0 and less than 1, using an internal pseudorandom algorithm (changes on recalculation).

#### 40. RANDBETWEEN

=RANDBETWEEN(bottom, top)

Returns a random number between the specified numbers.

#### 41. SQRT

=SQRT(number)

Returns the square root of a number.

#### 42. SUBTOTAL

=SUBTOTAL(function_num, ref1, [ref2], [ref3], …)

Returns a subtotal in a list or database.

### Section D – FIND and SEARCH FUNCTIONS

#### 43. FIND

=FIND(find_text, within_text, [start_num])

Returns the starting position of one text string within another text string. FIND is case-sensitive.

#### 44. SEARCH

=SEARCH(find_text, within_text, [start_num])

Returns the number of the character at which a specific character or text string is first found, from left to right (not case-sensitive).

#### 45. SUBSTITUTE

=SUBSTITUTE(text, old_text, new_text, [instance_num])

Replaces the old text with new text in a text string, with the optional value announcing what repetition of the old text to replace.

#### 46. REPLACE

=REPLACE(old_text, start_num, num_chars, new_text)

Replaces a part of a text string with a different text string.

### Section E – LOOKUP FUNCTIONS

#### 47. MATCH

=MATCH(lookup_value, lookup_array, [match_type])

Returns the relative position of an item in an array that matches a specified value in a specified order.

#### 48. LOOKUP

=LOOKUP(lookup_value, lookup_vector, [result_vector])

Looks up a value either from a one-row or one-column range or from an array. Obsolete in new versions of Excel, provided for backward compatibility.

#### 49. HLOOKUP

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Looks for a value in the top row of a table or array of values and return the value in the same column from a row you specify.

#### 50. VLOOKUP

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Looks for a value in the leftmost column in a table, then return a value in the same row from a column you specify. By default, the table must be sorted in an ascending order.

### Section F – REFERENCE FUNCTIONS

Creates a cell reference as text, given the specified row and column numbers.

#### 52. CHOOSE

=CHOOSE(index_num, value1, [value2], [value3], …)

Chooses a value or action to perform from a list of values, based on an index number.

#### 53. INDEX

Array Form: =INDEX(array, row_num, [column_num])

Return the value of a specified cell or array of cells.

Reference Form: =INDEX(reference, row_num, [column_num], [area_num])

Returns a reference to specified cells.

#### 54. INDIRECT

=INDIRECT(ref_text, [a1])

Returns the reference specified by a text string.

#### 55. OFFSET

=OFFSET(reference- rows, cols, [height], [width])

Returns a reference to a range that is a given number of rows and columns from a given reference.

### Section G – DATE and TIME FUNCTIONS

#### 56. DATE

=DATE(year, month, day)

Returns the number that represents the date in Microsoft Excel date-time code.

#### 57. DATEVALUE

=DATEVALUE(date_text)

Converts a date in the form of text to a number that represents the date in the Microsoft Excel date-time code.

#### 58. TIME

=TIME(hour, minute, second)

Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format.

#### 59. TIMEVALUE

=TIMEVALUE(time_text)

Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988424 (11:59:59 PM). Formats the number with a time format after entering the formula.

#### 60. NOW

=NOW()

Returns the current date and time formatted as a date and time.

#### 61. TODAY

=TODAY()

Returns the current date formatted as a date.

#### 62. YEAR(),  MONTH(),  DAY(), HOUR(), MINUTE(), SECOND()

YEAR(), MONTH(), DAY(), HOUR(), MINUTE() and SECOND() Functions

All these functions take one the serial_number argument and return the respective time slice.

#### 63. WEEKDAY

=WEEKDAY(serial_number, [return_type])

Returns a number from 1 to 7 identifying the day of the week from a date.

#### 64. DAYS

=DAYS(end_date, start_date)

Returns the number of days between the two dates.

#### 65. NETWORKDAYS

=NETWORKDAYS(start_date, end_date, [holidays])

Returns the number of whole workdays between two dates.

#### 66. WORKDAY

=WORKDAY(start_date, days, [holidays])

Returns the serial number of the date before or after a specified number of workdays.

### Section H – MISCELLANEOUS FUNCTIONS

#### 67. AREAS

=AREAS(reference)

Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.

#### 68. CHAR

=CHAR(number)

Returns the character specified by the code number from the character set for your computer.

#### 69. CODE

=CODE(text)

Returns a numeric code for the first character in a text string, in the character set used by your computer.

#### 70. CLEAN

=CLEAN(text)

Removes all non-printable characters from text. Examples are Tab or New Line characters. Their codes are 9 and 10.

#### 71. TRIM

=TRIM(text)

Removes all spaces from a text string except for single spaces between words.

#### 72. LEN

=LEN(text)

Returns the number of characters in a text string.

#### 73. COLUMN() and ROW() Functions

=COLUMN([reference])

Returns the column number of a reference.

=ROW([reference])

Returns the row number of a reference.

#### 74. EXACT

=EXACT(text1, text2)

Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.

#### 75. FORMULATEXT

=FORMULATEXT(reference)

Returns a formula as a string.

#### 76. LEFT(), RIGHT(), and MID() Functions

=LEFT(text, [num_chars])

Returns the specified number of characters from the start of a text string.

=MID(text, start_num, num_chars)

Returns the characters from the middle of a text string, given a starting position and length.

=RIGHT(text, [num_chars])

Returns the specified number of characters from the end of a text string.

#### 77. LOWER(), PROPER(), and UPPER() Functions

=LOWER(text)

Converts all letters in a text string to lowercase.

=PROPER(text)

Converts a text string to proper case – the first letter in each word in uppercase, and all other letters to lowercase.

=UPPER(text)

Converts a text string to all uppercase letters.

#### 78. REPT

=REPT(text, number_times)

Repeats text a given number of times.

#### 79. SHEET

=SHEET([value])

Returns the sheet number of the referenced sheet.

#### 80. SHEETS

=SHEETS([reference])

Returns the number of sheets in a reference.

#### 81. TRANSPOSE

=TRANSPOSE(array)

Converts a vertical range of cells to a horizontal range, or vice versa.

#### 82. TYPE

=TYPE(value)

Returns an integer representing the data type of a value: number = 1, text = 2; logical value = 4, error value = 16; array = 64.

#### 83. VALUE

=VALUE(text)

Converts a text string that represents a number to a number.

### Section I – RANK FUNCTIONS

#### 84. RANK

=RANK(number, ref, [order])

This function is available for compatibility with Excel 2007 and earlier.

Returns the rank of a number in a list of numbers: its size relative to other values in the list.

#### 85. RANK.AVG

=RANK.AVG(number, ref, [order])

Returns the rank of a number in a list of numbers. If more than one value has the same rank, the average rank is returned.

#### 86. RANK.EQ

=RANK.EQ(number, ref, [order])

Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the top rank of that set of values is returned.

### Section J – LOGICAL FUNCTIONS

#### 87. AND

=AND(logical1, [logical2], [logical3], [logical4], …)

Checks whether all arguments are TRUE, and returns TRUE when all arguments are TRUE.

#### 88. NOT

=NOT(logical)

Changes FALSE to TRUE, or TRUE to FALSE.

#### 89. OR

=OR(logical1, [logical2], [logical3], [logical4], …)

Returns FALSE only when all arguments are FALSE.

#### 90. XOR

=XOR(logical1, [logical2], [logical3], …)

Returns TRUE only if exactly one of the arguments is TRUE.

Provide a Valid Email below to download the PDF and Excel Files with 102 Excel Functions.

<< Go Back to Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1. Dear Kawser
If is wonderful to have you share your love for Excel.

Thanks.

• same!

• Hi Roger,
Thanks and regards.

• Pls send me sir ms Excel all formula sheet

• I am having the same problem. I’ve checked my email and confirmed my sign-up but cannot find the download?

• Hi Gina,
Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page.
Best regards
Kawser

• same issue here. plz send to my inbox. Thanks

2. Dear Kawser Bhai,

3. Although I have been already subscribed, I cannot download the Macro ebook and the Functions. It always be required an email adress. If I insert it, I get an error that I’m already subscribed.
Thanks

4. Wonderful resource, unfortunately experiencing the exact same problem as the users above.

5. Yep subscribed but no email link!

• Borb,
Regards
Kawser

7. Hi Kawser,

Already subscribed, can you share the Formula Cheat Sheet. Thanks

9. I had the same problem as everyone else. Embarrassing since I shared the link on LinkedIn. :O\

• Hey Tricia,
I checked several times the link. There is no problem with the link 🙂 This is not a direct download link. You have to subscribe to get the cheat sheet. I hope you should not be embarrassed with the shared link.
Best regards
Kawser

Muhammad Sohail Ashraf Oct 29, 2016 at 1:16 AM

subscribed but did not find any downlaod link?

12. I have subscribed and waiting for my download link. Kindly send the link to my email. I have an interview later in the day. Thank you, Kawser.

13. Hello,

Thanks,
Kaz

14. Hello Kawser

I am facing issue on page script error. Please send me 100+Excel Formulas Cheat Sheet on my email id.

Thanks

15. Excellent support from this site.

16. Please send me the excel!

17. I subscribed! Please send me 100+Excel Formulas Cheat Sheet to my email

18. Nice

19. Hello! I have subscribed to your newsletter, but am not able to find the link for the Excel Formulas Cheat Sheet. Please can you send? THANK YOU!

20. July 2017 and I’m having the same issue, no link to download the cheat sheet in my email

23. Hi Kawser
I’m having the same issue, send cheat sheet on my Email address

Thanks.

25. Cannot download example file. It keeps directing me to mailchimp and then I’m seeing error because I’m already subscribed.

• Hi Ajeet,
Then you can download it from the Excel Resources Page that you get in every email I send.
Thanks.

27. Hello! thank you for your hard work … I have the same problem … I did register but wouldn’t allow me to download … could you please send me the link? My email is : [email protected]

• Please check your email. I have sent the file. Thanks and sorry for the inconvenience.

• It is sent. Check out your email.

• Hello, I am struggling as well. can I have it too via email, please?

30. hlo sir can you please share me advance excel formulas list.

• Hi Manzis,
Thanks.

33. Kindly send me on my mail, [email protected]

Paulina Van Velzen Jan 10, 2022 at 7:06 PM

It is more help for me

36. Hi Kawser,

I would like to inform you that this information is very useful, but can’t download list of formulas. I am very thankful to you if you share these list of formulas in my mail id.

Thanks & Regards
Puspesh Das

37. I am James Garang
Am interested in the useful excel formula and I need to download it

• Hello sir “ when i use excel in iPad i confused excel shourtcut key is not working in ipad

• Hello Aniket!

As of now, we are only focusing on Microsoft Excel for Windows. But in case of other versions, there are some shortcut keys that do not work for iPad yet. It is constantly getting updated. If only some of the shortcuts aren’t working for you, then that may be the case. One solution would be to stay up to date with their updates.

38. This is a fantastic resourse. Thank you!

40. All excel formula

• Hello MS,

Thanks
ExcelDemy

42. Excellent formulas I am a student I need it’s sir

44. hi,

Please could you share Excel Formulas Cheat Sheet PDF & Excel Files

45. Thanks..
Good job

Syed Anees Haider Zaidi Jun 1, 2023 at 4:32 PM

Can anyone send me this file through email please? [email protected]

47. Sir kindly send me the link as well
[email protected]

48. Wow..I’m very new to excel…the cheat sheet is a must!

49. Thank you so much. I got it

Good to hear that. To get more helpful contents explore our site.

Regards
ExcelDemy