Custom Data Validation Formula

[Cammandk]

I am using this formula successfully in a cell that the user enters a £ value.
They can't enter a value in Q16 without selecting from a dropdown in F16 (F,O,I,E,B,P,S,R) and then a date in G16.

=AND(NOT(ISBLANK($F16)),NOT(ISBLANK($G16)))

I need to enhance this. I need the value entry in Q16 not to be allowed based on the following
If F16 = F,O,E,R - F16/G16 need to be completed
If F16 = I,B,S - F16/G16/P16 need to be completed

Thanks

 

[SirJB7]

Hi, Cammandk!

Try this:
=AND(NOT(ISBLANK($F16)),NOT(ISBLANK($G16)),OR(($F16="F",$F16="O",$F16="E",$F16="R"),NOT(ISBLANK($P16))))

Regards!

 

[Cammandk]

Hi SirJB
When I copy this across into either field or DV input box it comes up with formla error?

Thanks.

 

[NARAYANK991]

Hi David ,

Can you try this ?

=OR(AND(ISNUMBER(SEARCH(F16,"FOER")),NOT(ISBLANK(F16)),NOT(ISBLANK(G16))),AND(ISNUMBER(SEARCH(F16,"IBS")),NOT(ISBLANK(F16)),NOT(ISBLANK(G16)),NOT(ISBLANK(P16))))

Narayan