Simple Code Help

[rwe1187]

I cannot believe I cant figure this out.. I need a simple code that will pop up a warning box when 2 values in 2 different cells do not equal a set of values. For instance, if a user puts c/o in cell c2 then the calue in e2 must be 0. If anything other than 0 when the c2 value is c/o an error must pop up. But, if the user places c/o in c2 and 0 in e2 then just accept the 0 and move forward.

Thank you.

 

[kweaver]

I think you're looking for Data Validation for E2 as: =AND(C2="c/o",E2=0)

 

[rwe1187]

I think you're looking for Data Validation for E2 as: =AND(C2="c/o",E2=0)

I knew someone would get it fast. Now if I wanted to make the "c/o" cell either "c/o" or "off" how would that look?

Thanks for the help.

 

[kweaver]

How about:

=AND(OR(C2="off",C2="c/o"),E2=0)

 

[rwe1187]

How about:

=AND(OR(C2="off",C2="c/o"),E2=0)

I was wrong. It does not work. If I put a value, any value, in c2 it will not allow me to put anything in e2.

 

[kweaver]

Restate the conditions that are valid and those that aren't.

 

[kweaver]

Maybe it's this:

=IF(AND(OR("off"=C2,"c/o"=C2),0<>E2),0,1)

 

[rwe1187]

Maybe it's this:

=IF(AND(OR("off"=C2,"c/o"=C2),0<>E2),0,1)

That was the fix. Thank you very much.