August 5, 2020 - by Bill Jelen
When you need to do a conditional calculation, the IF function is the answer. It works like this: If <something is true>, then <this formula>; otherwise <that formula>. In the following figure, a simple IF calculates a bonus for your sales of more than $20,000.
But what happens when two conditions need to be met? Most people will nest one IF statement inside another, as shown below:
Excel 2020: Protect Rows with an Array Formula »
August 3, 2020 - by Bill Jelen
Here is an odd use for an array formula: Say that you don‘t want anyone to delete or insert any rows in one section of a worksheet.
Excel 2020: Turn Data Sideways with a Formula »
July 30, 2020 - by Bill Jelen
Someone built this lookup table sideways, stretching across C1:N2. I realize that I could use HLOOKUP instead of VLOOKUP, but I prefer to turn the data back to a vertical orientation.
Microsoft Excel 2019 Pivot Table Data Crunching »
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.
Microsoft Excel 2019 VBA and Macros »
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.
Excel Custom Functions Straight to the Point »
Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.
Excel 2019 Business Basics & Beyond »
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.
MrExcel 2020 - Seeing Excel Clearly »
This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.
Cleaning Excel Data With Power Query Straight To The Point »
This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.