If statement with cell validation

  • Thread starter Thread starter Hank
  • Start date Start date
H

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force input in multiple cells in Excel form 8
Excel locking cell based on value in another cell 1
Tricky Formula 2
error in my VBA (newbie) 3
Macro: If(And(... 4
IF AND VLOOKUP formula needed 1
value of one cell in a named range 3
Excel Locking cells based on value in another cell 2

Back
Top