What is IF function in Excel?
IF function is one of logical functions in Microsoft … Read More
Calculate conditional mode with criteria in Excel
To calculate a conditional mode with one or more criteria you can use an array … Read More
How to set check register balance in Excel
This tutorial shows how to set a check register formula that calculates a running balance … Read More
Basic outline numbering in Excel
This tutorial shows how to create 1st and 2nd level outline formatting using excel formulas.… Read More
Calculate Conditional Percentile ‘IF’ in table in Excel
To calculate a conditional percentile, you can use an array formula using the IF function … Read More
How to get last row in mixed data with blanks in Excel
To get the last relative position (i.e. last row, last column) for mixed data that … Read More
How to test for all values in a range are at least in Excel
To test if all values in a range are at least a certain threshold value, … Read More
How to strip numeric characters from cell in Excel
To remove numeric characters from a text string, you can try this experimental formula based … Read More
Find most frequent text within a range with criteria in Excel
To find the most frequently occurring text in a range, based on criteria you supply, … Read More
How to count total words in a cell in Excel
To count the total words in a cell, you can use a formula based on … Read More
How to calculate next scheduled event in Excel
To get the next scheduled event from a list of events with dates, you can … Read More
Get work hours between dates and times in Excel
To calculate total work hours between two dates and times, you can use a formula … Read More
Roll back weekday to Friday base on a particular date in Excel
List holidays between two dates in Excel
To list holidays that occur between two dates, you can use a formula based on … Read More
Calculate total hours that fall between two times in Excel
Case study
You have a start time and an end time, and you want to … Read More
Generate series of dates by weekends in Excel
This tutorials covers how to generates Series of dates increment by weekends from a single … Read More
Calculate series of dates by workdays in Excel
This tutorials covers how to generate series of dates increment by workdays from a single … Read More
Add line break based on OS in Excel
To add a line break taking into account the current OS (Mac or Windows), you … Read More
How to compare two text strings in Excel
If you need to compare two text strings in Excel to determine if they’re equal, … Read More
How to check cell contains which things in Excel
If you have a list of things (words, substrings, etc) and want to find out … Read More
How to display conditional message with REPT function in Excel
To display a conditional message, without the IF function, you can use boolean logic and … Read More