Formula

Generally, the hour is a unit of time in a day. A day has twenty-four hours. Each hour has 60 minutes. In Excel, we can… Read More »How to Use Excel HOUR Function?

In general, dates are the significant ones for making any events, programs, functions, etc. Because we should decide the time of the event on a… Read More »How to Use Excel DATE Function?

Generally, TRUE or FALSE are two logical expressions representing 1 and 0 respectively. On that note, if we want to check whether the given condition… Read More »How to Use Excel TRUE Function?

If you are a regular Excel user and want to return a value as the replacement for the #N/A error in Excel, then there should… Read More »How to Use Excel IFNA Function?

Sometimes, we want to find the occurrences of a specific character in a word. Instead of counting it manually, we can use the Excel COUNTCHAR… Read More »Formula to Count Occurrences of a Character in a String in Excel!

The maximum value is the largest number of a set of values. Sometimes, we want to get the largest value from the list, it can be… Read More »Formulas to Find Maximum Value with Multiple Criteria in Excel!

Excel has a RANK function, so you can calculate the rank of each number that stands in a list in your spreadsheet. Instead of using… Read More »Formulas to Rank Items with One or more Criteria in Excel!

Sometimes you need to sum values in columns based on adjacent criteria in a range, What would you do? We suggest you use the formula… Read More »Formulas to Sum Columns based on Adjacent Criteria in Excel!

In Excel, how could we count the cells with multiple criteria? There is a formula with the COUNTIF function in Excel. By applying it to… Read More »Formulas to Count Cells with Multiple OR Criteria in Excel!

In Excel, how could we extract the content from a specified row and column? There is a formula with INDIRECT and ADDRESS functions in Excel.… Read More »Formulas to Get Content of Given Row & Column in Excel!