div error

[MonkeyNut]

Greetings everyone. Yayyy back in my favourite forums. Please can anyone tell me how to get rid of this DIV Error and calculate regardless of error? My total also showing a div.

Thanks and have a grand day
MN ♪♫♪

 

[JAMIR]

Hi MonkeyNut,

Please put this formula in D4

=IFERROR(C4/B4,"") and Drop up to end.


Zameer

 

[NARAYANK991]

Hi ,

Just use an IF function ; the overall average is never the sum of individual averages ; you need to divide the overall weight by the total number of bobbins.

Narayan

 

[MonkeyNut]

Thank you and beeeegg Hugs to all your genius in Chandoo. I love it here. Mwahs
MN

 

[Khalid NGO]

Hi,

Another option:

=IF(AND(B4>=1,C4>=1),C4/B4,"")