# Data validation query

#### Pauljj

##### Well-known Member
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

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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...

perfect, thanks very much

Replies
1
Views
351
Replies
2
Views
576
Replies
0
Views
206
Replies
0
Views
273
Replies
0
Views
225

1,203,629
Messages
6,056,417
Members
444,862
Latest member
more_resource23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back