Learn Excel Episode 767: #VALUE Errors

Posted in Companies, Podcasts on July 16, 2008



A question asks how to avoid #VALUE errors when a formula refers to a cell with a blank text value. In Episode 767, I will take a look at how these blank cells come to be, how to work around the #VALUE error and even a different approach to prevent the root cause of the problem.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas, if, ISBLANK, Number Format, Zeroes