Data Validation formula problem
 

I am trying to create a data validation formula. I want it to protect from
user input that doesnt meet the following:
€¢ If F50 = €œClose€� or if F50 = €œLast€�
And If F31<€�€�
Then F61 needs to be F31.
€¢ If F50 = €œOpen€� I dont care what the input is.
€¢ If F31 is blank (€œ€�) then there can be no input in F61 since we cannot
verify
against a value in F31.

(Note F50 is a drop down box that gives the user choices of €œOpen€�, €œClose€�
or €œLast€� only.)

One way:

Allow: Custom
Formula: =AND(F31<"",OR(F50="Open",F61F31))


In article ,
rrucksdashel wrote:

I am trying to create a data validation formula. I want it to protect from
user input that doesnt meet the following:
€¢ If F50 = €œClose€� or if F50 = €œLast€�
And If F31<€�€�
Then F61 needs to be F31.
€¢ If F50 = €œOpen€� I dont care what the input is.
€¢ If F31 is blank (€œ€�) then there can be no input in F61 since we cannot
verify
against a value in F31.

(Note F50 is a drop down box that gives the user choices of €œOpen€�, €œClose€�
or €œLast€� only.)