Data Validation C2*D2 = E2

[clarksonneo]

Hi,

I would like to apply Data Validation on column E.
This criterion is C1*D1 = E1
Eg, if C1 = 10 AND D2 = 1, then E1 can be 20 only

How can I do that?

Thanks

[Bob Phillips]

Exactly as written, apply that formula to Data Validation

=C1*D1=E1

[nepotist]

In the Custom Formula Enter the

=E2=C2*D2
That should work

[Bob Phillips]

Exactly as written, apply that formula to Data Validation

=C1*D1=E1