+ Reply to Thread
Results 1 to 2 of 2

To shorten the formula

  1. #1
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2010 (office) 2013 (home)
    Posts
    255

    To shorten the formula

    Hi

    Is there any formula that can shorten the below while having the same result? As when i need to add one more function into the cell, it stated "formula too long".

    Please Login or Register  to view this content.
    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: To shorten the formula

    I think it's fair to summarise (please correct me, of course, I can't see the raw data...)

    =if( iserror( <complex lookup 1> ), 0, <complex lookup 1> ) + if( iserror( <complex lookup 2> ), 0, <complex lookup 2> )

    You could split the formulae like so:
    column 1 = <complex lookup 1>
    column 2 = <complex lookup 2>
    column 3 = if( iserror( <column 1 value> ), 0, <column 1 value> ) + if( iserror( <column 2 value> ), 0, <column 2 value> )

    This has the added benefit of making it easier to edit the formulae as each lookup is only written once (and so only needs editing once if you need to change it).

    You can easily hide the preceding columns.

    HTH
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ 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