Data Validation custom formula - how to apply?

[D_N_L]

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.

: (

[Vikas_Gautam]

I think...
in data validation ..
you just need to enter the "Allowed" or "not Allowed"
there is no need to enter the whole formula..
as you are entering it in the sheet itself...


click * to appreciate..

[popipipo]

=and(LEFT(A1,1)="A",RIGHT(A1,3)+0>B1)
Does this work?

[D_N_L]

Of course! AND!

Thank you!!

Thanks Vikas for replying too.