Solved: Data Validation - Formula Question

[gimli]

Hi,

I am using the following data validation formula for a cell.

=OR(AND((VALUE(MID(C2,5,4))>138),LEFT(C2,3)="389",RIGHT(C2,1)="S"),AND(LEFT (C2,3)<>"389",(VALUE(MID(C2,5,4))>200)))

My understanding is that if the formula returns a true value, the error window will pop up. For some reason this formula is not working as a data validation formula but works fine if I test it as a formula in a cell on the spread sheet.

any thoughts would be great.

[mikerickson]

The rule for Validation formulas is to Allow values when the formula retunrns True.

[Bob Phillips]

You have to use the DV in the C2 cell.

[gimli]

Ok..so I changed the formula to this had it bass ackwards.

thanks much

=OR(AND((VALUE(MID(C2,5,4))<=138),LEFT(C2,3)="389",RIGHT(C2,1)="S"),AND(LEF T(C2,3)<>"389",(VALUE(MID(C2,5,4))<=200)))