Hi all,

I have this formula - works perfectly well. How do I apply it using Custom DV? I add it to the formula within the DV custom dialog and it just throws up the DV error on anything I enter.

=IF(LEFT(A1,1)="A",IF(RIGHT(A1:A1,3)+0>B1,"Allowed","Not allowed"),"Allowed")

I have tried removing the True/False statements as I guess they're not allowed. Still no joy though.

: (