I have a cell (A14) that is blank (\"\"). I want to add a validation to cell A16

Question

I have a cell (A14) that is blank (""). I want to add a validation to cell A16 that cell that says if cell A14 is blank (""), then A16 must be blank. The intent is that if A14 is blank, a user cannot enter anything into A16 without triggering the error. Conversely, if a number is entered into A14, then a number should be able to be entered into A16. I tried this validation formula in A16:

IF(A14=""), "")

The results of that formula are:

Is it because I'm missing the "otherwise" part in the formula??? I thought that was optionaal. If that is the issue, how does one represent "any number" in the formula. Ideas???

Thanks,

Explanation / Answer

You can use this as a data validation formula for A16 and you will then only be able to enter data when there is a number in A14

=isnumber(A14)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.