In this video I demonstrate three ways to display zeros as blanks. Download the featured file here. Method One: Use the IF Function Using the IF function we can return an empty text string in place of a zero result. In the example below the current stock level is calculated by…
Read More
How to Make Multiple Selections in an Excel Drop-Down List
In this video I show you to create a drop-down list in Excel that lets you select multiple items. Download the featured file here. Please note the featured file does not contain the VBA code required to complete the task. Unfortunately, WordPress does not allow me to upload macro-enabled workbooks. Step…
Read More
How to Calculate Age in Excel from Date of Birth or Specific Date
In this video I demonstrate how to calculate a person's current age as well as how to calculate their age on a specific date. Download the featured file here. Calculate a Person's Current Age The formula to calculate a person's current age is: =YEARFRAC(B2, TODAY()), where B2 is the cell that…
Read More