Sign up for our free Insiders program and get the example file:
Click here: https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0257 Keep blanks
★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/
★ About this video ★
In this video, we tackle the issue of blank cells being displayed as zeros during calculations in Excel.
We will explore the issue, and address some of the common pitfalls.
By the end, you will have an easy-to-apply custom function to apply whenever you face this issue.
00:00 Introduction
00:23 The problem of blank cells
00:53 Why does this happen?
01:15 Don't replace zeros
03:16 When does blank become zero
03:38 Using the ISBLANK Function
04:19 Creating a Custom Function
05:19 Testing
06:36 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel