Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

A common criticism of Excel's SWITCH function is that it only handles exact matches, such as turning the number 1 into the word "Active." If you want to use greater-than or less-than symbols, most ...

If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

Excel’s SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions came to mind as I was watching a 1969 film called If It’s Tuesday, This Must Be Belgium, about American tourists on a whirlwind tour of ...

Here are a few quick methods of analyzing records to find out what's been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...

Discover how Excel's Goal Seek reverses calculations to find input values from known outcomes and enhances your data analysis skills.

Discover how to calculate present value (PV) in Excel, exploring concepts like future value, interest rates, and periods for ...

You will get an error if Flash Fill cannot find the pattern. The first thing to check is that you're using Flash Fill close to the source data (e.g., in the adjacent cell). For instance, it won't work ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...