Excel Formula Examples

How to Sum Range Ignoring Errors in Excel

This post will guide you how to sum range of cells ignoring Errors in Excel. How do I sum and ignore errors with a formula in Excel. How to sum range ignoring all error values with VBA macro in Excel. Sum Range Ignoring Errors with Formula Sum Range Ignoring Errors with VBA Sum Range Ignoring… read more »

How to Use SUMIF with Multiple Criteria in Same Column in Excel

This post will guide you how to SUMIF with multiple criteria in same column in Excel. How do I use SUMIF with multiple criteria in one column in Excel. SUM Cells with Multiple Criteria in Same Column Assuming that you have a list of data in range A1:B6, in which contain sales data. And you… read more »

How to Limit the Number of Decimal Places in Excel

This post will guide you how to limit the number of decimal places in Excel. How do I round a number to the specific decimal places with a formula in Excel. How to Limit Number of decimal places with Format Cell Feature in Excel. Limit Number of Decimal Places with in Formula Limit Number of… read more »

How to Pick a Random Name from a List in Excel

This post will guide you how to pick a random name from a list in Excel. How do I select random value from a list or a table with a formula in Excel 2013/2016. Pick Random Name from a List Assuming that you have a list of names in range B1:B6, and you want to… read more »

How to Convert Days to Years, Months, Days in Excel

This post will guide you how to convert a given day numbers into Years, Months, Days in Excel. How do I convert days to Years, Months, Days with a formula in Excel. How to convert a general numbers to a standard date in Excel. Convert Days to Years, Months, Days Convert General Number to Standard… read more »

How to Convert Julian Date to a Calendar date in Excel

This post will guide you how to convert Julian date to a calendar date in Excel. How do I convert a given Julian Date to a calendar date with a formula in Excel. What is Julian Date? Julian day number ┬áis the integer assigned to a whole solar day in the Julian day count starting… read more »

How to Extract Text between Two Text Strings in Excel

This post will guide you how to extract text between two given text strings in Excel. How do I get text string between two words with a formula in Excel. Extract Text between Two Text Strings Assuming that you have a list of data in range B1:B5, in which contain text string values. And you… read more »

Sidebar