conditional validation

0

i have 2 cells A1 AND A2, A1 is a drop down box with two options YES/NO. Now my requirement is if I select YES in A1, A2 should be 0(Zero) by default and if A1 is NO, then i could enter my desired value.

Is there any such formulae in Excel?

Kindly tell me.

Answer
Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
cappymer1 (rep: 120) Apr 10, '17 at 12:18 pm
Add to Discussion

Answers

0

Try this as a custom validation formula:

=IF(A1="no",TRUE,IF(A1="yes",A2=0))

However, the user will have to enter 0 into cell A2 or leave it blank. With fomulas, this can't happen automatically.

Discuss

Discussion

Hi Thnx for your reply, i have applied this formula in custom validation, but it is not working. When i select "YES" in A1 cell, the A2 it is not showing 0.
Kiran Apr 10, '17 at 10:45 pm
Did you read that last sentence in my answer?

If you want 0 to automatically populate, try out Kevin UK's answer.
don (rep: 1482) Apr 12, '17 at 5:48 am
Add to Discussion
0

What if you use C1 for your default value?

=IF(A1="YES",0,C1)

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login