Step 6 Hide If Error Message in Column J

Step 6

Hide the Error Messages

Watch the video

or
follow the
Step by Step
Instructions.

Step 6 - Let's Hide the Error Message

Step by Step Instructions

Step 6a Select Cell J3. The cell that has the

Error Message.

Step 6b Edit the Average Formula, =AVERAGE(B3:I3)


Step 6 c	Put your cursor between the = sign and the A in average.
Step 6d	Type iferror(
Step 6e	Put your cursor behind the last )
Step 6f	Type a comma , open quote " 3 DASHES --- close quote " and a ) Enter

Step 6g) Your "If Error Formula" should look like this:

Step 6h) Use the "skinny plus +" to extend the NEW Formula all the way down the column.

Select Cell J3 > Move your mouse around until it changes to a "skinny plus." >
Click > Hold > Drag down the column > until you reach J11 > Release.

Step 7 Hide Row 11
Error Message

Table of Contents for Part 1

How to get rid of the Error Message Video. When you have an AVERAGE Formula in a cell but there are no numbers in the cells you'll get the Error Message Step 6. Let's Hide the Error Message
How to get rid of the Error Messages	3:05 min