Results 1 to 18 of 18

Formula Too Long Problem

Threaded View

Gallegos Formula Too Long Problem 09-12-2021, 05:11 PM
menem Re: Formula Too Long Problem 09-12-2021, 10:56 PM
Gallegos Re: Formula Too Long Problem 09-15-2021, 11:14 PM
XLent Re: Formula Too Long Problem 09-13-2021, 04:43 AM
Gallegos Re: Formula Too Long Problem 09-15-2021, 12:34 AM
kvsrinivasamurthy Re: Formula Too Long Problem 09-13-2021, 06:16 AM
kvsrinivasamurthy Re: Formula Too Long Problem 09-13-2021, 06:34 AM
Gallegos Re: Formula Too Long Problem 09-15-2021, 12:27 AM
Bo_Ry Re: Formula Too Long Problem 09-13-2021, 06:57 AM
Gallegos Re: Formula Too Long Problem 09-14-2021, 10:10 PM
menem Re: Formula Too Long Problem 09-13-2021, 09:56 PM
Gallegos Re: Formula Too Long Problem 09-14-2021, 06:09 PM
Gallegos Re: Formula Too Long Problem 09-14-2021, 06:23 PM
menem Re: Formula Too Long Problem 09-14-2021, 10:08 PM
kvsrinivasamurthy Re: Formula Too Long Problem 09-15-2021, 03:19 AM
kvsrinivasamurthy Re: Formula Too Long Problem 09-16-2021, 01:51 PM
Gallegos Re: Formula Too Long Problem 09-16-2021, 11:28 PM
kvsrinivasamurthy Re: Formula Too Long Problem 09-17-2021, 12:53 AM
  1. #1
    Registered User
    Join Date
    07-22-2019
    Location
    United States
    MS-Off Ver
    2010
    Posts
    15

    Formula Too Long Problem

    Hello fellow members. I am having a problem with a formula too long issue that I am hoping you
    can help me with. I have a table of parts and within that table there can be 10 different models
    and it can be sold in 20 different markets.

    This table structure is used extensively throughout the workbook, so I am hoping I don't have to
    change it in order to accomplish what I need to, which is to sum the total # of parts sold by month
    for each model & each market the part is sold. Not every model may use the part and so the
    user would just enter a zero for the quantity in the table under that model.

    The part cost may be higher or lower than the base cost in each of the 20 markets sold and so the
    user can enter a % increase/decrease for each of the 20 markets. However, not every market will
    sell the part & so my thought was to have the user enter a 0% in the market increase % to indicate
    this.

    The problem is that when I multiply the quantity used by each of the ten models for each of the
    20 markets (if the % of the market is zero) I get the error the formula is too long. I have tried to
    come up with a different methodolgy, but so far have not been able to come up with anything &
    still accomplish what I need to without changing the base structure of the table.

    I have attached an Excel workbook as an example. The formula that is highlighted in the Parts
    Sold Table shows the formula for just two models and two markets. If this formula is expanded to
    include the ten models & 20 markets I need Excel indicates it's too long.

    I look forward to any assistance you can provide me.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Substitute formula lower and upper case character and long text problem
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-08-2016, 09:41 AM
  2. Problem with recording a macro with long formula - works in Excel but not in macro
    By tonybeo2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2015, 11:25 AM
  3. Long Array Formula Problem
    By tnederlof in forum Excel General
    Replies: 12
    Last Post: 08-20-2009, 02:55 PM
  4. Problem with a long formula
    By sa02000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2008, 11:59 AM
  5. Formula too long problem.
    By zipp in forum Excel General
    Replies: 4
    Last Post: 06-15-2007, 06:32 PM
  6. [SOLVED] Formula too long problem
    By rfritz in forum Excel General
    Replies: 2
    Last Post: 06-09-2006, 01:20 PM
  7. Problem with VBA returning the contents of a long formula.
    By alfred.vachris@gmail.com in forum Excel General
    Replies: 2
    Last Post: 02-22-2005, 09:06 PM

Tags for this Thread

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