Data Validation and IF

[Tony2021]

Hello,

I need to limit the input of range of cells in Column C based on following criteria:

if B2>A2 then C2 must be >0

if B2<A2 then C2 must be <0

if B2=A2 then C2 must be =0

Please see attached file. 

thank you

[#2 · Accepted solution]

@Tony2021 

Rule 2 is not possible unless you are doing time travel into the past.

=SIGN(C2)=SIGN(B2-A2)

[#3]

that was perfect! Ingenious. FYI: that rule 2 is possible though. Your solution worked perfectly!

Quadruple: I am not sure if I was using it correctly but it didnt seem to return the result I was expecting.