Removing #DIV/0 in IF formula

[Rufus 2019]

I have a problem I just can't figure out. I have a formula in cell O6, =IF($B3=1,AVERAGE($G6:$L6),""), that works great. However, If the criteria in B3 is met and I don't enter anything in G6:L6, O6 returns #DIV/0. The question is how do I get rid of the error and get O6 to show as a blank cell?

Thank you for the help.

Rufus

 

[mikerickson]

You could use =IFERROR(IF($B3=1,AVERAGE($G6:$L6),""), "")

 

[petertenthije]

Add this to your existing code:

=IFERROR(IF($B3=1,AVERAGE($G6:$L6),""),””)

 

[Rufus 2019]

mikerickson:

Thank you. That works great.

Rufus

 

[Rufus 2019]

Report
petertenthije:

Thank you. It works great.

Rufus