CODEWITHSUNDEEP
excel-formula
Nesreen
Nesreen

Reputation: 1

Find a proper formula to calculate average with zero when cells are blank

I have a formula to calculate sum of 3 cells one of them is a product of average of other three cells. the problem is when calculating the average of these cells while they are blank it gives error Div/0 and then the corresponding calculations are error too

maybe the solution is that if I want to calculate average of range of blank cells that the result to be zero but I dont know how to do this.

Upvotes: 0

Views: 277

Answers (1)

Cheche
Cheche

Reputation: 1516

Replace your formula with =IFERROR(<Your formula>, 0) to avoid getting unwanted errors with blank cells.

If you're using spanish version, you should use: =SI.ERROR(<Your formula>; 0). Note the change between , and ; between versions.

Thanks to @ForwardEd for noting my mistake!

Upvotes: 1

Related Questions