# To long formule for excel 2003

1. ## To long formule for excel 2003

Hi I have en formule that i made in excel 2007, but i need open it also in excel 2003.
When I do that I get a message 'to must genest levels'.

Sampel:
=ALS(K\$6=\$E7;\$D7;ALS(K\$6>\$F7;0;ALS(\$E7+(1*\$H7)=K\$6;\$D7;ALS(\$E7+(2*\$H7)=K\$6;\$D7;ALS(\$E7+(3*\$H7)=K\$6;\$D7;ALS(\$E7+(4*\$H7)=K\$6;\$D7;ALS(\$E7+(5*\$H7)=K\$6;\$D7;ALS(\$E7+(6*\$H7)=K\$6;\$D7;ALS(\$E7+(7*\$H7)=K\$6;\$D7;ALS(\$E7+(8*\$H7)=K\$6;\$D7;ALS(\$E7+(9*\$H7)=K\$6;\$D7;ALS(\$E7+(10*\$H7)=K\$6;\$D7;ALS(\$E7+(11*\$H7)=K\$6;\$D7;ALS(\$E7+(12*\$H7)=K\$6;\$D7;ALS(\$E7+(13*\$H7)=K\$6;\$D7;ALS(\$E7+(14*\$H7)=K\$6;\$D7;ALS(\$E7+(15*\$H7)=K\$6;\$D7;ALS(\$E7+(16*\$H7)=K\$6;\$D7;ALS(\$E7+(17*\$H7)=K\$6;\$D7;ALS(\$E7+(18*\$H7)=K\$6;\$D7;ALS(\$E7+(19*\$H7)=K\$6;\$D7;ALS(\$E7+(20*\$H7)=K\$6;\$D7;ALS(\$E7+(21*\$H7)=K\$6;\$D7;ALS(\$E7+(22*\$H7)=K\$6;\$D7;ALS(\$E7+(23*\$H7)=K\$6;\$D7;ALS(\$E7+(24*\$H7)=K\$6;\$D7;ALS(\$E7+(25*\$H7)=K\$6;\$D7;ALS(\$E7+(26*\$H7)=K\$6;\$D7;ALS(\$E7+(27*\$H7)=K\$6;\$D7;ALS(\$E7+(28*\$H7)=K\$6;\$D7;ALS(\$E7+(29*\$H7)=K\$6;\$D7;ALS(\$E7+(30*\$H7)=K\$6;\$D7;ALS(\$E7+(31*\$H7)=K\$6;\$D7;ALS(\$E7+(32*\$H7)=K\$6;\$D7;ALS(\$E7+(33*\$H7)=K\$6;\$D7;ALS(\$E7+(34*\$H7)=K\$6;\$D7;ALS(\$E7+(35*\$H7)=K\$6;\$D7;ALS(\$E7+(36*\$H7)=K\$6;\$D7;ALS(\$E7+(37*\$H7)=K\$6;\$D7;ALS(\$E7+(38*\$H7)=K\$6;\$D7;ALS(\$E7+(39*\$H7)=K\$6;\$D7;ALS(\$E7+(40*\$H7)=K\$6;\$D7;0))))))))))))))))))))))))))))))))))))))))))

How can I make this compatible fore excel 2003?
The formule is stil the same 'Als...' only n* is form 1 to 40

2. ## Re: To long formule for excel 2003

Not sure what you are doing here, but this should do the same (and is much shorter):

=ALS(K\$6=\$E7;\$D7;ALS(K\$6>\$F7;0;ALS(AND((K\$6-\$E7)/\$H7=INT((K\$6-\$E7)/\$H7);(K\$6-\$E7)/\$H7>=1;(K\$6-\$E7)/\$H7<=40);\$D7;0)))

I don't know what the Dutch is for INT (meaning to take the integer value) or AND (both highlighted in red), so you will need to change these to the words in your version of Excel.

Hope this helps.

Pete

3. ## Re: To long formule for excel 2003

I've put the formula into the 4 cells in column K and copied them across so you can see it working.

Hope this helps.

Pete

4. ## Re: To long formule for excel 2003

Maybe in K7, Drag Across to the end of your table then Down.
Formula:
`Please Login or Register  to view this content.`

Try, Dutch
Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1