gimli

12-13-2010, 06:53 AM

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.

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.