Rufus 2019
New Member
- Joined
- Feb 1, 2019
- Messages
- 11
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
Thank you for the help.
Rufus