Conditional formula

[LoganTrk]

Hello guys , I need a validation , if in column A it is -100, column B must be -100 but if in the column A has any other value, column B can have any value. I have this formula but when entering for example the number 1 in the column A , and i put number 2 in column B I ger an error.

=IF(A4=-100;B4=-100;"")

 

[Sam_D_Ben]

Recalled.

 

[AlphaFrog]

Hello guys , I need a validation , if in column A it is -100, column B must be -100 but if in the column A has any other value, column B can have any value. I have this formula but when entering for example the number 1 in the column A , and i put number 2 in column B I ger an error.

=IF(A4=-100;B4=-100;"")

Your DV formula is saying that if A4 = -100 then B4 must = -100 else B4 = "" (blank)

Try this...
=IF(A4=-100;B4=-100;TRUE)

This says Else whatever is in B4 is TRUE