Validation expression too long

[SoniaIna]

Hi,

My validation expression is too long:
=IF(H1<6;AND(H10>0;OR(H10<=E10;ISNUMBER(FIND($AD$20;H10;1));ISNUMBER(FIND($AD$25;H10;1));ISNUMBER(FIND($AD$26;H10;1));UPPER(H10)=$AD$15:$AD$28));IF(H1=32;AND(H10>0;OR(H10<=E10;ISNUMBER(FIND($AD$26;H10;1));AND(H10>0;OR(H10<=E10;ISNUMBER(FIND($AD$20;H10;1));ISNUMBER(FIND($AD$25;H10;1));ISNUMBER(FIND($AD$26;H10;1))))

In the H10 cell I want to user to force to use the following:

1. IF H1<6, it can be a number between 0 and the value of E10 or one of the symbols from the cells AD15:AD28 or a number+one of the values from AD20,AD25,AD26

2. IF H1=32 , it can be a number between 0 and the value of E10 or a number+one of the values from AD26

3. IF H1=6 OR H1=7 it can be a number between 0 and the value of E10 or a number+one of the values from AD20,AD25,AD26

H1 can only be 1,2,3,4,5,6,7,32.

Thank you.

 

[Sandeep Warrier]

Hi

What are the values in AD20,AD25,AD26?

Also, what will the value in H10 look like for the case

a number+one of the values from AD20,AD25,AD26

 

[SoniaIna]

Hi,

In AD20 I have A, in AD25 I have I, AD26 I have S. From AD15 to AD28 I have other letters which I can fill in H10.
So in H10 I can put a number 2,3,4...8, one of the letters from AD15:AD28

or A or 4A or S or 4S or 4I . (4 can be any number lower then 8)
Only A,S,I is allowed to use in combination with letters.


Thanks!

<table width="50" border="0" cellpadding="0" cellspacing="0"><col style="width: 38pt;" width="50"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; width: 38pt;" width="50" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl64" style="height: 12.75pt; border-top: medium none;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt; border-top: medium none;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt; border-top: medium none;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt;" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt;" height="17">
</td></tr><tr style="height: 13.5pt;" height="18"><td class="xl66" style="height: 13.5pt;" height="18">
</td></tr></tbody></table>