Forum

Notifications
Clear all

#Div/0!

3 Posts
2 Users
0 Reactions
63 Views
(@mymalone)
Posts: 103
Estimable Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

Perfect!  Thank you 

 
Posted : 19/04/2018 11:46 pm
Share: