Hello
I have a question. I have a spreadsheet with three columns. Only one of the
columns must contain 1 and other two will be then 0. I need to automate the
following tast:

If I input 1 in one cell (of any of the three columns), then others two
cells should automatically change their values to 0.

Any help in this matter will be appreciated.
Thanks.

Trying2Learn