+ Reply to Thread
Results 1 to 4 of 4

To long formule for excel 2003

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    holland
    MS-Off Ver
    Excel 2007
    Posts
    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
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    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. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    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
    Attached Files Attached Files

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: To long formule for excel 2003

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

    Try, Dutch
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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