## Fix XLOOKUP #SPILL Error

Learn to easily fix an XLOOKUP #SPILL Error in Excel. Chances are if you have been working with Dynamic Array Formulas in Excel, you have run across a …

Skip to content# Formulas

## Fix XLOOKUP #SPILL Error

## Boolean Logic in Excel

## Effective Rate of Return in Excel

## Multiple Criteria XLOOKUP

## Calculate Shipping Days Left in a Month

## Subtract If Greater than Zero

## Sum if date is greater than

## Sum if greater than

Scroll to Top
Formulas are expressions that utilize defined values and provide a calculation. Formulas provide computational power for your spreadsheets.

Learn to easily fix an XLOOKUP #SPILL Error in Excel. Chances are if you have been working with Dynamic Array Formulas in Excel, you have run across a …

What is Boolean logic in Excel? So, how do you use Boolean logic and how can it be used in Excel. Changes are you have heard this term …

Learn how to calculate the effective rate of return in Excel. The Effective Annual Return (EAR) is the annual rate per year of an investment taking into consideration …

Learn how to use XLOOKUP with multiple criteria in Excel. In our example, we will show how you can use the XLOOKUP Function with multiple criteria. The functionality …

Quickly learn how to calculate the number of shipping days left in a month using a simple formula in Excel. Does your job require you ship packages or …

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a cell is greater than zero. Let’s …

Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range if the date is past our …

To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use the SUMIF Function to sum all …