Learn 151 all Excel Formulas list How To Use step by step With Examples

Excel Function Dictionary
Function Dictionary

01-20
***

How I Learned Abs Formula Andbecame Successful

Isblank Formula Under A Bluesky

Introducing Stdevp Formula In A New Light

11 Things Your Boss Expects You to Know About Address Excel Formulas

How Iserr Excel Formulas Can Keep You Out of Trouble 

SUBSTITUTE: Replacing one text string with another within a cell or range

ISERROR: Handling errors in a formula by returning a specified value instead

Ten SUM FORMULA Tips You Need To Learn Now.

AND 

ISLOGICAL: Testing whether a value is a logical value (TRUE or FALSE)

10 Unexpected Uses for Sum as Running Totals

AREAS

ISNA: Testing whether a value is the #N/A error value

SUM using named ranges: Adding up a range of cells identified by a descriptive name

AVERAGEIF: Finding the average of values in a range that meet a specified condition

ISNONTEXT Function: Testing whether a cell contains non-text values

Excel's SUM with OFFSET Function: What It Is and How to Use It

CEILING: Rounding a number up to the nearest integer or specified multiple of an integer

Excel's ISNUMBER Function: What It Is and How to Use It

SUMIF: Adding up values in a range that meet a specified condition

21-40
***

Extracting Cell Data with Excel's CELL Function

Using Excel's ISREF Function to Test for Cell References

SUMPRODUCT: Multiplying corresponding values in two or more arrays and adding the results

Excel's CHAR Formula: A Powerful Tool for Converting ASCII Codes to Characters

Mastering the ISTEXT Function in Excel: Tips and Tricks

Advanced Techniques for Using the SYD Formula in Excel

CHOOSE: Returning a value from a list of values based on an index number

Getting Started with LARGE in Excel: A Step-by-Step Guide

TUnderstanding the T Function and its Applications in Excel

Clean Your Data with Excel's Clean Formulas: A Step-by-Step Guide

LEFT: Extracting a specified number of characters from the left side of a text string 

TEXT: Converting a value to text using a specified format code.

Using CODE to Manipulate Text and Perform Conditional Formatting in Excel

LEN: Counting the number of characters in a cell or range

Time Functions: Choosing the Right Approach for Time Calculations in Excel

Using Combin to Solve Real-World Problems and Improve Analysis in Excel

LOOKUP (Array)

Using Timevalue to Convert Dates and Times for Analysis in Excel

CONCATENATE: Combining text strings or values into a single cell

Simplifying Data Retrieval with Excel's Lookup Formulas 

41-60
***

TODAY: Getting the current date

Using Correl to Identify Trends and Patterns in Your Data in Excel

LOWER: Converting text to lowercase letters 

Using Transpose to Merge Data from Multiple Sources in Excel

Using Count to Filter and Analyze Data in Excel

MATCH: Looking up a value in a table using the INDEX and MATCH functions 

Excel's Trend Formula: A Powerful Tool for Predictive Analysis

Count And CountA

MAX: Finding the highest value in a range or array

TRIM: Removing leading and trailing spaces from a string.

COUNTBLANK

MEDIAN: Finding the median value of a set of data 

TRUNC: Truncating a number to a specified number of decimal places

COUNTIF: Counting the number of cells in a range that meet a specified condition

MID: Extracting a specified number of characters from the middle of a text string 

UPPER: Converting text to uppercase letters

date

 MIN: Finding the lowest value in a range or array

Value

DATEDIF: Calculating the difference between two dates in years, months, or days

61-80
***

MINUTE 

Var

DateValue

 MMULT

Varp

DAVERAGE

MOD 

VLOOKUP: Looking up a value in the leftmost column of a table and returning a value from the same row in a specified column

DAY: Extracting the day from a date

MODE: Finding the mode value(s) of a set of data 

WEEKDAY: Finding the day of the week for a given date

Using DAYS360 to Calculate Interest and Payment Schedules in Excel

 MONTH: Extracting the month from a date

 YEAR: Extracting the year from a date

Excel's DB Formula: A Powerful Tool for Asset Management and Planning

Excel's N Formula: A Powerful Tool for Numeric Conversions and Calculations

Understanding the DCOUNT Function and its Applications in Excel

Excel's NA Formula: A Powerful Tool for Error Handling and Troubleshooting

Simplifying Complex Calculations with the DCOUNTA Formula in Excel

81-100
***

NOT: Negating a logical value (i.e., returning true if the value is false, and false if the value is true)

Understanding the DGET Function and its Applications in Excel

Using the NOW Formula for Real-Time Data Analysis in Excel

Understanding the DMAX Function and its Applications in Excel

ODD: Rounding a number up to the nearest odd integer

Excel's DMIN Formula: A Powerful Tool for Database Analysis

 OR: Evaluating multiple conditions and returning true if any are true, false if all are false

Excel's Dollar Formula: A Powerful Tool for Financial Analysis

 Using the Permut Formula to Solve Combinatorial Problems in Excel

"DSUM Function: Summing Data Based on Multiple Conditions in Excel"

Calculating Pi using the PI Formula in Excel

 BIN2DEC

EAST 

"Excel's POWER Function: A Quick and Easy Guide"

 Converting Units with CONVERT Excel Formula"

Understanding Error Types and Resolving Them with Excel's ERROR.TYPE Function

Solving Complex Math Problems Using the PRODUCT Function in Excel

 DEC2BIN

EVEN: Rounding a number up to the nearest even integer

PROPER: Capitalizing the first letter of each word in a text string.

100-120
***

 DEC2HEX

Learn EXACT Excel formula

 QUARTILE: Finding the quartiles of a set of data

 DELTA: Testing whether two numbers are equal

FACT: Calculating the factorial of a number

RAND: Generating a random decimal number between 0 and 1

EDATE: Adding or subtracting a specified number of months to a date

FIND: Finding the position of a substring within a string

RANK: Ranking a number within a set of numbers

EOMONTH: Finding the end date of a specified month based on a given date

FIXED: Rounding a number to a specified number of decimal places and displaying it as text

REPLACE: Replacing a portion of a text string with a new text string

How to Find the Greatest Common Divisor (GCD) in Excel

FLOOR: Rounding a number down to the nearest integer or specified multiple of an integer

REPT: Repeating a text string a specified number of times

GESTEP: Testing whether a number is greater than or equal to a threshold value and returning a specified value if true or false

FORECAST: Predicting future values based on existing data using linear regression analysis

RIGHT: Extracting a specified number of characters from the right side of a text string

HEX2DEC: Converting a hexadecimal number to decimal

121-140

***

FREQUENCY: Counting the number of values in a data set that fall within a series of specified intervals

ROMAN: Converting a number to Roman numerals

ISEVEN: Determining if a number is even

FREQUENCY: Counting the number of values in a data set that fall within a series of specified intervals

ROUND: Rounding a number to a specified number of decimal places

ISODD: Determining if a number is odd

HLOOKUP: Looking up a value in the top row of a table and returning a value from the same column in a specified row

ROUNDDOWN: Rounding a number down to a specified number of decimal places

LCM: Finding the least common multiple of two or more numbers

HOUR: Extracting the hour component from a time value

ROUNDUP: Rounding a number up to a specified number of decimal places

MROUND: Rounding a number to the nearest multiple of a specified value

IF: Testing a condition and returning one value if the condition is true, and another value if the condition is false

 SECOND: Returning the second component of a time value

NETWORK

DAYS: Calculating the number of days between two dates

141-151
***

INDEX: Retrieving a value from a specified row and column of a range of cells

SIGN: Determining the sign of a number (positive, negative, or zero)

QUOTIENT: Dividing two numbers and returning only the integer quotient

INDIRECT: Returning a reference to a cell or range of cells based on a text string

SLN: Calculating the straight-line depreciation of an asset over its useful life

RANDBETWEEN: Generating a random integer between two specified values

INFO: Returning information about the current operating environment

SMALL: Returning the nth smallest value from a range of values

WORKDAY: Calculating the date that is a specified number of workdays from a starting date

INT: Rounding a number down to the nearest integer

STDEV.S: Calculating the standard deviation of a sample

YEAR: Extracting the year from a date

FRAC