Notifications
Clear all
Topic starter
How do I get rid of the #DIV/0!. Here's my formula =AverageIf(B2:B13,"<>0").
I would like to graph the data but I cannot because of the #DIV/0!.
Can you offer any insight?
Thanks
Posted : 19/04/2018 5:30 pm
Depending on the graph, you can use either
=IFERROR(AverageIf(B2:B13,"<>0"),0)
or
=IFERROR(AverageIf(B2:B13,"<>0"),NA())
Hope this helps
Sunny
Posted : 19/04/2018 7:07 pm
Topic starter
Perfect! Thank you
Posted : 19/04/2018 11:46 pm