Conditional Cell Validation

[cypher]

I have an Excel file where I have a cell A1 that has to be YES or NO,
Simple enough, I created a drop down list.

Trouble comes in with a second cell, B1. It MUST be a percentage for
other formulas throughout the rest of the sheet to work correctly. But
this percentage value ONLY makes sense if A1 is YES, if A1 is NO, then
I need B1 to be forced BLANK, or at least to 0.00%

I am not sure how to do this.

-cypher

 

[Cutter]

In B1 put

=IF(A1="NO","",your %age)

or

=IF(A1="NO",0,your %age

 

[Guest]

=IF(A1="NO","",your_%_formula)

HTH
Jason
Atlanta, GA

 

[cypher]

I should have clarified something. The percentage has to be user selected
from a predefined list (Validation drop-down list) from another sheet in the
workbook. I would like this drop down to be UNACCESSABLE and the cell value
to be a " " (blank space) unless A1 = YES.

Hope that more clearely demonstrates my goal. Thanks for the suggestions!!

-cypher

 

[Debra Dalgleish]

Create a range named "Zero" --
Type a zero in a cell
Select that cell
Click in the Name Box, at the left of the formula bar
Type: Zero
then press the Enter key

Create a range with your percents, named "RateList" --
Type your rates in a list in the workbook
Select those cells
Click in the Name Box, at the left of the formula bar
Type: RateList
then press the Enter key

Select cell B1
From the Allow dropdown, choose: List
In the Source box, type:
=IF(A1="Yes",RateList,Zero)
Click OK

I should have clarified something. The percentage has to be user selected
from a predefined list (Validation drop-down list) from another sheet in the
workbook. I would like this drop down to be UNACCESSABLE and the cell value
to be a " " (blank space) unless A1 = YES.

Hope that more clearely demonstrates my goal. Thanks for the suggestions!!

-cypher