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