+ Reply to Thread
Results 1 to 2 of 2

amending existing formula to blank when there is no data

  1. #1
    Registered User
    Join Date
    06-28-2017
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    13

    amending existing formula to blank when there is no data

    Hi

    I would like to have the formula return the cell as blank when both Sheet1 & 2 cells H2 are both empty (if one or the other has data it should return false or true)

    =IF(OR(AND(Sheet1!H2="Sell", Sheet2!H2="Buy"), AND(Sheet1!H2="Buy", Sheet2!H2="Sell")),"TRUE", "FALSE")

    Thanks

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: amending existing formula to blank when there is no data

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

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] amending existing formula to return blank when there is no data
    By chumster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2017, 03:30 AM
  2. [SOLVED] Need to add 2 extra blank rows to an existing blank row that separates data groups
    By terryhenderson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2017, 06:32 PM
  3. [SOLVED] Get existing Formula to return blank instead of 0 please
    By fruit&veg in forum Excel General
    Replies: 4
    Last Post: 01-22-2016, 07:53 AM
  4. [SOLVED] Amending Existing Code for Extracting Information from Outlook Folder
    By XOR LX in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 10:32 AM
  5. [SOLVED] Amending existing macro (removing restrictions)
    By index9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2013, 01:47 AM
  6. Help amending existing marco for a criteria search on a database
    By howardjo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2008, 07:01 AM
  7. [SOLVED] Amending an existing function
    By Paydog4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2006, 11:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1