+ 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 2013
    Posts
    240

    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 2000/3/7/10/13/16
    Posts
    45,364

    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

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

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

    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 2000/3/7/10/13/16
    Posts
    45,364

    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: 2010, 2016
    Posts
    6,279

    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)

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