+ Reply to Thread
Results 1 to 4 of 4

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
    231

    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
    43,311

    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 some-1 helped you

    Regards
    Ford

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

    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
    43,311

    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

+ 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