Forum Discussion
Solved
Data Validation and IF
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
Rule 2 is not possible unless you are doing time travel into the past.
=SIGN(C2)=SIGN(B2-A2)
Rule 2 is not possible unless you are doing time travel into the past.
=SIGN(C2)=SIGN(B2-A2)- 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.
