Data Validation formula problem

I am trying to create a data validation formula. I want it to protect from
user input that doesn�t meet the following:
� If F50 = �Close� or if F50 = �Last�
And If F31<>��
Then F61 needs to be > F31.
� If F50 = �Open� I don�t 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",F61>F31))


In article <[email protected]>,
rrucksdashel <[email protected]> wrote:

> I am trying to create a data validation formula. I want it to protect from
> user input that doesn’t meet the following:
> • If F50 = “Close” or if F50 = “Last”
> And If F31<>””
> Then F61 needs to be > F31.
> • If F50 = “Open” I don’t 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.)