+ Reply to Thread
Results 1 to 5 of 5

Adjust formula to add IF, two 0's cells, leave blank

  1. 08-26-2017, 06:38 PM #1
    Beh162
    Beh162 is offline
    Forum Contributor
    Join Date
    01-15-2015
    Location
    New York
    MS-Off Ver
    Excel 2011 MAC
    Posts
    104

    Adjust formula to add IF, two 0's cells, leave blank

    I need help adding another rule to my formula, I need it to also say IF U17 and X17 both have 0 in them, then leave blank

    Formula Y17

    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    If two cells have 0, then leave blank and also if two cells are blank then leave blank

    Thanks for the help
    Reply With QuoteRegister To Reply
  2. 08-26-2017, 06:43 PM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,876

    Re: Adjust formula to add IF, two 0's cells, leave blank

    Try this:

    =IF(AND(U17=0,X17=0),"",IF(AND(U17="",X17=""),"",IF(X17+V17=U17,"Push", IF(X17+V17>U17,W17,T17))))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-26-2017, 06:48 PM #3
    Root_
    Root_ is offline
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    485

    Re: Adjust formula to add IF, two 0's cells, leave blank

    Or a shorter one:

    =IF(OR(U17="",X17="",AND(U17=0,X17=0)),"",IF(X17+V17=U17,"Push", IF(X17+V17>U17,W17,T17)))
    Reply With QuoteRegister To Reply
  4. 08-26-2017, 06:53 PM #4
    Beh162
    Beh162 is offline
    Forum Contributor
    Join Date
    01-15-2015
    Location
    New York
    MS-Off Ver
    Excel 2011 MAC
    Posts
    104

    Re: Adjust formula to add IF, two 0's cells, leave blank

    Awesome!! Thanks so much to both!
    Reply With QuoteRegister To Reply
  5. 08-26-2017, 07:22 PM #5
    Root_
    Root_ is offline
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    485

    Re: Adjust formula to add IF, two 0's cells, leave blank

    You are welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add to existing match index formula a formula that will leave cells blank
    By Hedy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-15-2017, 02:34 PM
  2. [SOLVED] Formula to leave cells blank or carry out date calculations depending on value in cell
    By surk in forum Excel General
    Replies: 3
    Last Post: 02-17-2016, 08:26 AM
  3. [SOLVED] Formula to leave cell Blank until cells of formula have data
    By mbauman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2015, 01:28 PM
  4. Conditional Formatting - how to leave blank cells blank - no colour until date populated
    By leanne2011 in forum Excel General
    Replies: 3
    Last Post: 02-09-2015, 09:00 AM
  5. [HELP] How to leave cells blank if another column is blank in a formula with multiple ifs.
    By odd90 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2013, 07:17 AM
  6. If all cells are complete select the latest date, if at least one is blank leave it BLANK
    By Abu Abdurakhim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2013, 12:27 AM
  7. How to fill formula down but skip every nth cell? i.e. leave blank cells between results
    By hyperlollipop in forum Excel General
    Replies: 4
    Last Post: 04-09-2012, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1