Formula for if a cell does not equal 0

[andrewb90]

I am looking for a formula for if B2,C2, or D2 does not equal 0, after that my data validation should work.

Thanks,

Andrew

 

[njimack]

=IF(COUNTIF(B2:D2,0)=0,Result if True, Result if False)

 

[Michael M]

try

=IF(OR(B2<>0,C2<>0,D2<>0),"do your stuff","don't do your stuff")

 

[andrewb90]

I tried this one:

=IF(OR(K39<>0,L39<>0,M39<>0),"do your stuff","don't do your stuff")
(changed it to K,L,M)
I have allow: whole number
Data: Not equal to
and ignore blank checked

Now when I type anything into the cells with the validation, nothing happens until I type a letter instead of a number.
I'm a little confused by that.

 

[andrewb90]

I keep trying to change the allow settings, but regardless, I don't seem to get what I want.

 

[Michael M]

Hang on......are you trying to put the formula into the Data Validation ??

 

[andrewb90]

Yes I am

 

[Michael M]

No, can't do that !!
Data Validation input is based on the conditions you set relative to that cell, not to the results of another cell.
If I understand correctly, you will have to write a formula for the cell that allows for certain conditions in other cells.
So,if you want the conditions in your cell to be governed by this

=IF(OR(B2<>0,C2<>0,D2<>0)

you will have to develop a formula to suit.

If the above is true, what do you want the user to insert into the DV cell ??
If false, also, what do you want in the DV cell ??

 

[andrewb90]

Ok, What I am trying to do is this:
in cells K42:M46 I want a popup box to appear when the user starts entering data into it IF:
K39 or L39 or M39 DO NOT equal '0'
Basically in those cells I have an formula that checks several numbers entered into the sheet, and if the result does not balance to 0, then a mistake in entering was made, and the user needs to be alerted so they can check it themselves.
Does this make sense to you?

Thanks,

Andrew

 

[Michael M]

So in the cells K42 to M46, why not use the formula

=IF(OR(K39<>0,L39<>0,M39<>0),"Balance error","")

"Balance Error" will then appear in all cells that contain the formula, if the above conditions are true, otherwise the cell will be blank.