Home »
MS Excel
Excel Formulas Cheat Sheet
By IncludeHelp Last updated : October 14, 2024
We have categorized this Excel cheat sheet into the following sections:
Date and Time Functions
1. TODAY
The TODAY() function returns the current date.
=TODAY()
2. NOW
The NOW() function returns the current date and time.
=NOW()
3. DATE
The DATE() function returns a date based on the given year, month, and day values.
=DATE(2024, 9, 12)
4. YEAR
The YEAR() function returns the year value from the given date.
=YEAR(A1)
5. MONTH
The MONTH() function returns the month value from the given date.
=MONTH(A1)
6. DAY
The DAY() function returns the day value from the given date.
=DAY(A1)
7. WEEKDAY
The WEEKDAY() function returns the day of the week as a number from the given date.
=WEEKDAY(A1)
8. DATEDIF
The DATEDIF() function returns the difference between two dates.
=DATEDIF(A1, B1, "D")
Basic Math Functions
1. SUM
The SUM() formula returns the sum of all the numbers in the given range.
=SUM(A1:A10)
2. SUBTRACTION
You can use the minus (-) operator to find the sum of the two values.
=A1 - B1
3. MULTIPLICATION
The multiplication (*) operator multiplies the two values.
=A1 * B1
4. DIVISION
The division (/) operator divides two values.
=A1 / B1
5. PRODUCT
The PRODUCT() function is used to find the multiplication of all numbers given a range.
=PRODUCT(A1:A10)
6. ABS
The ABS() function returns the absolute value of the given value or cell.
=ABS(A1)
7. POWER
The POWER() function returns the result of raising the power of given two values.
=POWER(A1, 2)
8. SQRT
The SQRT() function returns the square root of the given value or cell.
=SQRT(A1)
9. SUMPRODUCT
The SUMPRODUCT() function multiplies corresponding values in two or more arrays and returns the sum of the products.
=SUMPRODUCT(A1:A5, B1:B5)
Rounding Functions
1. ROUND
The ROUND() function returns the rounded value of the given number to the given decimal places.
=ROUND(A1, 2)
2. ROUNDUP
The ROUNDUP() function returns the rounded value of the given number up to a given number of decimal places.
=ROUNDUP(A1, 2)
3. ROUNDDOWN
The ROUNDDOWN() function returns the rounded value of the given number down to a given number of decimal places.
=ROUNDDOWN(A1, 2)
4. CEILING
The CEILING() function returns the rounded value of the given number up to the nearest multiple of the given number.
=CEILING(A1, 1)
5. FLOOR
The FLOOR() function returns the rounded value of the given number down to the nearest multiple of the given number.
=FLOOR(A1, 1)
6. MROUND
The MROUND() function returns the rounded value of the given number to the nearest multiple of the given number.
=MROUND(A1, 5)
Advanced Math Functions
1. MOD
The MOD() function returns the remainder of the given two values.
=MOD(A1, B1)
2. INT
The INT() function returns the rounded value of the given number down to the nearest integer.
=INT(A1)
3. TRUNC
The TRUNC() function returns the truncated value of the given number to the specified number of decimal places.
=TRUNC(A1, 2)
4. PI
The PI() function returns the value of Pi (3.14159265...).
=PI()
5. EXP
The EXP() function returns the value of the mathematical constant e raised to the power of the given number.
=EXP(A1)
6. LOG
The LOG() function returns the logarithm of the given number to the given base.
=LOG(A1, 10)
7. LN
The LN() function returns the natural logarithm of the given number to the base e.
=LN(A1)
8. FACT
The FACT() function returns the factorial of a number (e.g., 5! = 5 * 4 * 3 * 2 * 1).
=FACT(A1)
9. RANDBETWEEN
The RANDBETWEEN() function returns a random integer between the given range.
=RANDBETWEEN(1, 100)
10. POWER
The POWER() function returns the result of the given number raised to the power of the given another (second) number.
=POWER(A1, 3)
Trigonometric Functions
This table shows the trigonometric functions, which generally work with angles:
| Function |
Example |
Description |
| SIN |
=SIN(A1) |
This function returns the sine of the given value that should be an angle (in radians). |
| COS |
=COS(A1) |
This function returns the cosine of the given value that should be an angle (in radians). |
| TAN |
=TAN(A1) |
This function returns the tangent of the given value that should be an angle (in radians). |
| ASIN |
=ASIN(A1) |
This function returns the arcsine of a number. |
| ACOS |
=ACOS(A1) |
This function returns the arccosine of a number. |
| ATAN |
=ATAN(A1) |
This function returns the arctangent of a number. |
| DEGREES |
=DEGREES(A1) |
This function converts radians to degrees. |
| RADIANS |
=RADIANS(A1) |
This function converts degrees to radians. |
1. IF
The IF() function is used to check a condition, it returns a value if the condition is true, another value otherwise.
=IF(A1>0, "Positive", "Negative or Zero")
2. AND
The AND() function returns true if all of the given conditions are true.
=AND(A1>10, B1<5)
3. OR
The OR() function returns true if any of the given conditions is true.
=OR(A1>10, B1<5)
4. NOT
The NOT() function returns TRUE if the given condition is false and returns False if the given condition is true.
=NOT(A1>10)
5. IFERROR
The IFERROR() function returns an error if there is any error in the given expression of the numbers.
=IFERROR(A1/B1, "Error")
Text Functions
1. CONCAT
The CONCAT() function returns the concatenated string. You can concatenate the values of the multiple cells along with the text provided in the double quotes.
=CONCAT(A1, " ", B1)
2. LEFT
The LEFT() function returns the given number of characters from the left of the text.
=LEFT(A1, 5)
3. RIGHT
The RIGHT() function returns the given number of characters from the right of the text.
=RIGHT(A1, 3)
4. MID
The MID() function returns a substring of the given number of characters starting from a given specified position.
=MID(A1, 3, 4)
5. LEN
The LEN() function returns the length of the given text.
=LEN(A1)
6. TRIM
The TRIM() function returns the result after removing all spaces except for single spaces between words.
=TRIM(A1)
7. UPPER
The UPPER() function returns the text converted into uppercase.
=UPPER(A1)
8. LOWER
The LOWER() function returns the text converted into lowercase.
=LOWER(A1)
9. PROPER
The PROPER() function returns the text converted into capital case, where each character of the word is in the uppercase and the rest of the characters are in the lowercase.
=PROPER(A1)
10. TEXT
The TEXT() function converts the value to text.
=TEXT(A1)
Lookup and Reference
1. VLOOKUP
The VLOOKUP() function looks for a value in the first column of a range and returns a value in the same row from another column.
=VLOOKUP(B1, A2:D10, 3, FALSE)
2. HLOOKUP
The HLOOKUP() function looks for a value in the first row of a range and returns a value in the same column from another row.
=HLOOKUP(B1, A1:D10, 3, FALSE)
3. INDEX()
The INDEX() function returns the value from a specific row and column in a range.
=INDEX(A1:C10, 2, 3)
4. MATCH
The MATCH() function returns the relative position of a value in a range.
=MATCH("Okay", A1:A10, 0)
5. INDIRECT
The INDIRECT() function returns the value of a cell specified by a text string.
=INDIRECT(A1)
1. PMT
The PMT() function calculates and returns the periodic payment for a loan based on the given interest rate, periods, and amount.
=PMT(interest_rate, periods, loan_amount)
2. NPV
The NPV() function calculates and returns the net present value of an investment based on the discount rate and cash flow values.
=NPV(discount_rate, A1:A5)
3. FV
The FV() function calculates and returns the future value of an investment based on the given interest rate, time periods, payment, and present value.
=FV(interest_rate, periods, payment, present_value)