Results 1 to 9 of 9

Showing a blank cell when no data is used. Or showing a blank cell formula unused

Threaded View

ntraviglia Showing a blank cell when no... 10-25-2016, 02:37 AM
AliGW Re: Lots of varaibles! 10-25-2016, 02:42 AM
jeversf Re: Lots of varaibles! 10-25-2016, 02:46 AM
AliGW Re: Lots of varaibles! 10-25-2016, 03:08 AM
ntraviglia Re: Lots of varaibles! 10-25-2016, 02:30 PM
Jonmo1 Re: Showing a blank cell when... 10-25-2016, 02:37 PM
ntraviglia Thank you so much. When I... 10-25-2016, 03:25 PM
ntraviglia Awesome! It DID work! Lol! I... 10-25-2016, 03:30 PM
Jonmo1 Re: Showing a blank cell when... 10-25-2016, 03:34 PM
  1. #1
    Registered User
    Join Date
    10-25-2016
    Location
    california
    MS-Off Ver
    excel 2013
    Posts
    7

    Showing a blank cell when no data is used. Or showing a blank cell formula unused

    So i need a formula that gives me an answer, but, remains blank if the cells are giving the formula no data to compute. Please see below. This is how far i have gotten, but, i need to add something that says if no entries/no results:

    =if(and(l13>3,m13>3,n13>3),"q","u")

    THIS WORKS GREAT AS IT SHOWS ME TRUE/FALSE (OR Q/U)

    BUT -

    WHEN I HAVE BLANK ENTRIES IN THOSE 3 CELLS, IT SHOWS ME "U" WHEN I NEED IT TO SHOW NOTHING AT ALL.
    Last edited by ntraviglia; 10-25-2016 at 02:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. BIG sheet with lots and lots of data to filter...
    By Amatør in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2016, 08:26 AM
  2. SUMPRODUCT with 3 VARAIBLES
    By illyacto in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-27-2015, 11:08 PM
  3. Switching from Excel 2010 to Excel 2013 lots, lots of errors
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2014, 11:23 AM
  4. [SOLVED] Formula based on varaibles
    By mattress58 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-16-2014, 12:10 PM
  5. Very New to VBA Need Lots Of Help
    By Mattwantshelp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2012, 08:49 PM
  6. Lots of graphs, lots of text boxes needed
    By sarasbluegroove in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-28-2011, 09:11 AM
  7. [SOLVED] Basic Question about varaibles
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2005, 09: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1