Data validation query

[Pauljj]

I have added this formula, all it says that there is a problem with it which I can't see, anyone any ideas ?

=AND($u$2="WK4",F347="SKI"),15),AND($u$2="WK5",F347="SKI"),20,IF($U$2="WK4",10,15)


So this should be for a maximum number setting. If U2 is WK4 and F347 is SKI then the maximum number should be 15, otherwise if U2 is WK5 and F347 is SKI then then maximum number should be 20, otherwise if U2 is WK4 and F347 is any other word then the maximum number should be 10, all other scenarios and the maximum number should be 15

 

[Aladin Akyurek]

Probably:

=IF($U$2="WK4",IF(F347="SKI",15,10),IF($U$2="WK5",IF(F347="SKI",20,15),15))

You need to check it though...

 

[Pauljj]

perfect, thanks very much