+ Reply to Thread
Results 1 to 5 of 5

Updating an existing formula to remove logic

  1. #1
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2016 Professional
    Posts
    388

    Updating an existing formula to remove logic

    See the attached example.

    I would like to create a new formula in Column BZ that is a copy of CA.

    How would the formula be updated to exclude any logic that references 'Order Status Adjustment'.

    I continue to receive error messages when making this update so any help would be appreciated.

    Thank you.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Updating an existing formula to remove logic

    When formulas start getting that complex (and have parts repeated elsewhere), it is sometimes better to start using helper columns to do some of the calcs for you. Maybe consider that approach?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2016 Professional
    Posts
    388

    Re: Updating an existing formula to remove logic

    Unfortunately, I need to update the formula (removing that one element) within the current formula because this is part of a larger project that I'm involved with.

    Any idea on how to remove references to that element?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Updating an existing formula to remove logic

    no, because I cannot even see where that element is. Your sheet is too wide and the nesting too complex for me to wade through, sorry

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Updating an existing formula to remove logic

    IMHO no logic references 'Order Status Adjustment'. It is used only to compute some values if logic based on Setup Description, Is Automated, Yearly OSL, etc requires so.
    But try removing references to this column (used as factor in multiplication) - may be this is what you look for:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Kaper; 09-19-2018 at 03:49 AM.
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Updating an Existing Formula (Removing Logic)
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2018, 09:44 AM
  2. Updating an Existing Formula (Override Logic)
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2018, 11:43 AM
  3. Deeper if then logic for existing fomula?
    By jriker1 in forum Excel General
    Replies: 4
    Last Post: 07-17-2017, 01:53 PM
  4. DAYS vs. NETWORKDAYS (Updating an existing formula)
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2017, 12:37 PM
  5. Calculation - Adding IF statement to existing logic
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-27-2016, 10:37 AM
  6. Replies: 1
    Last Post: 08-15-2009, 05:52 AM

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