Excel Forum

#Div/0!

mymalone

Member

Members

Forum Posts: 104

Member Since:
August 25, 2017

Offline

April 19, 2018 - 7:30 am

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

SunnyKow

Puchong, Malaysia

VIP

Members

Trusted Members

Forum Posts: 1432

Member Since:
June 25, 2016

Offline

April 19, 2018 - 9:07 am

Depending on the graph, you can use either

=IFERROR(AverageIf(B2:B13,"<>0"),0)

=IFERROR(AverageIf(B2:B13,"<>0"),NA())

Hope this helps

Sunny

mymalone

Member

Members

Forum Posts: 104

Member Since:
August 25, 2017

Offline

April 19, 2018 - 1:46 pm

Perfect! Thank you

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: MohamedGadAllah, Jeff Krueger, Kylara Papenfuss, Janset Beyaz, Shawn Barwick, Nada Perovic

Guest(s) 8

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Ray-Yu Yang

George Shihadeh

Naomi Rumble

Uwe von Gostomski

Jonathan Jones

drsven

Forum Stats:

Groups: 3

Forums: 24

Topics: 6212

Posts: 27236

Member Stats:

Guest Posters: 49

Members: 31889

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen