+ Reply to Thread
Results 1 to 2 of 2

Updating an existing formula to override current logic

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

    Updating an existing formula to override current logic

    Hello,

    My current formula is outputting the value of a cell from another sheet OR a '-' if not found.

    =IF(SHEET1!$AP$1=0,"-",SHEET1!$AP$1)

    If Column L = '1', I would like to update the above formula to say 'AUTOMATED' regardless if there is a value present.

    How would I go about doing that?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,865

    Re: Updating an existing formula to override current logic

    perhaps this... =IF(SHEET1!L1=1,"AUTOMATED",IF(SHEET1!$AP$1=0,"-",SHEET1!$AP$1))
    your post is marked as solved, you might want to remove that unless you solved it.
    AND, you have L='1' so I am making the assumption it is numeric not a text value and it is in cell L1.
    AND also, I don't know if you want it to be an absolute cell reference or not so make it SHEET1!$L$1 if you want it absolute.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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 to remove logic
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2018, 03:37 AM
  2. Updating an Existing Formula (Removing Logic)
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2018, 09:44 AM
  3. Updating an Existing Formula (Override Logic)
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2018, 11:43 AM
  4. Need checkbox to override existing formula
    By tilson in forum Excel General
    Replies: 4
    Last Post: 11-11-2017, 05:24 AM
  5. VLOOKUP override existing cell value
    By gammaman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2013, 07:59 PM
  6. Need a override for already existing List validation
    By appunu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2010, 03:15 PM

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