I have cell validation in cells E11, E12, & E13.

I would like to make this if statement --- if E11 = "None" then E12 and
E13 default to "N/A". Possibly there is a better method than an "if
statement".

Can this be done (and how) and keep the current cell validation?
Thanks

Can't default them to N/A that I know of, but you can force input of N/A
with a formula of

=AND($E$11="None", E12="N/A") in E12

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hank" wrote in message
.. .
I have cell validation in cells E11, E12, & E13.

I would like to make this if statement --- if E11 = "None" then E12 and
E13 default to "N/A". Possibly there is a better method than an "if
statement".

Can this be done (and how) and keep the current cell validation?
Thanks