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:

	A	B	C	D	E
1	SKU	A Difference	B Difference	C Difference	Overall Discrepancy?
2	EX1			0
3	EX2		-50	0

<tbody>
</tbody>

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!