If statement with cell validation

[Hank]

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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>