If three sets of multiplied cells added together equal zero then blank

[Nanaia]

I'm trying to figure out why my IF formula doesn't work. I want the result to be a blank cell but it gives me FALSE. It is possible for any one (or all) of the multiplied cells to be blank which is why I added the IFERROR to them.

Can anyone give me a pointer?

=IF((IFERROR((J49*D49),0)+IFERROR((J50*D50),0)+(IFERROR(J51*D51,0)))=0,"")

 

[Fluff]

What should happen if they don't total to 0?

 

[Nanaia]

What should happen if they don't total to 0?

Provide whatever the results of the equation are, unless it's an error then I need to figure out why it's giving an error.

 

[Joe4]

Is this what you are after?

=IFERROR((J49*D49)+(J50*D50)+(J51*D51),"")

 

[Fluff]

Ok, how about

=IF(SUMPRODUCT(D49:D51,J49:J51)=0,"",SUMPRODUCT(D49:D51,J49:J51))

 

[Nanaia]

Is this what you are after?

=IFERROR((J49*D49)+(J50*D50)+(J51*D51),"")

This removes the Zero and leaves the cell blank, however it doesn't display the total when there is a value greater than zero.

 

[Nanaia]

Ok, how about

=IF(SUMPRODUCT(D49:D51,J49:J51)=0,"",SUMPRODUCT(D49:D51,J49:J51))

This was successfully removes the zero leaving a blank cell AND provides the sum if there is one. Thank you.

 

[Joe4]

This removes the Zero and leaves the cell blank, however it doesn't display the total when there is a value greater than zero.

It does for me in my testing.

If it is not working for you, please present an example where it is not working.
Please let us know exactly what is in each of those 6 cells being referenced in the formula.

 

[Fluff]

Glad we could help & thanks for the feedback.

Joe
For me, your formula only leaves a blank cell if the formula results in an error, it does leave a blank cell if the total is 0

 

[Joe4]

For me, your formula only leaves a blank cell if the formula results in an error, it does leave a blank cell if the total is 0

OK, I was not getting that they wanted to high the 0 result in addition to any error. I thought they were just trying to hide the errors.
I guess that is mentioned in the title, but not in the question.

This removes the Zero and leaves the cell blank, however it doesn't display the total when there is a value greater than zero.

I also was not getting that if one row returned a total, and one row returned an error, you want to ignore the errors and show the total.