PDA

View Full Version : Data Validation C2*D2 = E2



clarksonneo
03-28-2011, 05:37 AM
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
03-28-2011, 05:53 AM
Exactly as written, apply that formula to Data Validation

=C1*D1=E1

nepotist
03-28-2011, 05:54 AM
In the Custom Formula Enter the

=E2=C2*D2
That should work

Bob Phillips
03-28-2011, 09:19 AM
Exactly as written, apply that formula to Data Validation

=C1*D1=E1