Need help with Validation formula

[gaurav4698]

Hi all,

How can i add following formula in dropdown validation
=IF(ISBLANK(C4),"N","Y")

 

[Asala42]

There may be another way but I know this way works:

- Enter an N in a cell, and a Y in another cell
- Create a named range with your formula, but reference cells instead of listing the "N" and "Y" as constants.
- Reference this named range in your validation. for example: =MyRangeName

 

[gaurav4698]

Any more solutions on this ?

 

[Danerida]

A drop down list needs to contain more than one value. Your formula results in either N (if C4 is blank) or Y (if C4 is not blank). Why not just have the formula in the cell?