ExcelBanter - Data Validation Using "IF" Function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation Using "IF" Function? (https://www.excelbanter.com/excel-discussion-misc-queries/153798-data-validation-using-if-function.html)

tony

Data Validation Using "IF" Function?

I am trying to set up a custom validation for cell A2, so that if A1 reads
"YES" A2 must be a specific formula. If A1 reads "NO" A2 can be anything
else.

Any suggestions?

PCLIVE

Data Validation Using "IF" Function?

Maybe this:
=IF(A1="YES",<YourFormula,"Anything else")

Regards,
Paul

--

"Tony" wrote in message
...
I am trying to set up a custom validation for cell A2, so that if A1 reads
"YES" A2 must be a specific formula. If A1 reads "NO" A2 can be anything
else.

Any suggestions?

All times are GMT +1. The time now is 08:16 PM.