Hi,

I would like to create a data validation.

In a coulmn, I would like to input number.
The things I input will have 2 forms only.

Form1: just number
Eg, 2000, 54.22,

Form2: number divided by 2
Eg, =2000/2, =50.2/2, = 101/2

How can I create such data validation?

Thanks