How to flag if cells in a row are not either blank or 0?

[Kenichi]

Hi,

I'm thinking this should be a pretty simple formula, but nothing I've tried has worked for me.

My sheet calculates pricing differences between two sources for different attributes (in this case A, B, and C attributes). Some cells are blank, some cells contain "0", and some cells contain a number if there was a discrepancy between prices. The data looks like:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]SKU[/TD]
[TD]A Difference[/TD]
[TD]B Difference[/TD]
[TD]C Difference[/TD]
[TD]Overall Discrepancy?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]EX1[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]EX2[/TD]
[TD][/TD]
[TD]-50[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What formula can I enter in column E to flag if the values in cells B, C, or D are not a blank or "0" value? In the above example, cell E3 should return an ERROR value, because cell C3 is not blank or "0".

Thanks!

 

[Takae]

hope this helps.

E3=IF(SUM(B3:D3)<>0,"Error","")

 

[Rick Rothstein]

hope this helps.

E3=IF(SUM(B3:D3)<>0,"Error","")

What about if B3 were +50 and C3 (as shown) was still -50 and D3 (as shown) was still 0?

I think this formula should work though...

E2 (copied down)
------------------------------------
=IF(TRIM(SUBSTITUTE(B2&C2&D2,0,""))="","","Error")

 

[Kenichi]

What about if B3 were +50 and C3 (as shown) was still -50 and D3 (as shown) was still 0?

I think this formula should work though...

E2 (copied down)
------------------------------------
=IF(TRIM(SUBSTITUTE(B2&C2&D2,0,""))="","","Error")

Perfect. That formula seems to be working great.

Thank you both!