Results 1 to 5 of 5

Trying to add to an existing formula to leave cell blank depending on value of another cel

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2015
    Location
    Texas, USA
    MS-Off Ver
    2013
    Posts
    3

    Trying to add to an existing formula to leave cell blank depending on value of another cel

    My boss is under the impression that I am an EXCEL expert, but I'm really close to proving him wrong. I have made a bunch of changes to an old spreadsheet for him, but I am stuck on the final bit. I need to add to a couple of formulas to cause them to return a blank cell based on the value of another cell. I have tried every iteration that I can think of but continue to fail. I have attached a copy of the sheet.

    The problem is that one of the sheets is looking for time values to sum and all of the extra data is really throwing off the numbers.

    Example:

    =IF($B$24<>0,$B$24+TIME(0,L$85,0),"")
    I would like to add a formula to return a blank cell if L6 is either blank or contains a zero.

    The same with this one: =IF($B$12>1,IF(L$7<>0,L7+TIME(0,$B$15,0),""),"")

    I feel like this should be simple to do, but my brain is now officially fried.

    Any assistance would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula needed to leave cell blank
    By jennijohnstone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2015, 07:41 AM
  2. Integrating leave blank cell if error into existing code
    By WinningKing in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2014, 12:12 AM
  3. Leave cell result blank if blank cell is in formula
    By Grind in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-28-2013, 06:15 AM
  4. If Then formula. If false, I would like to leave the cell blank.
    By joaquinwalking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2013, 01:56 PM
  5. [SOLVED] Leave a cell with a formula blank until another is filled in
    By andyking40 in forum Excel General
    Replies: 7
    Last Post: 10-31-2012, 06:15 AM
  6. Formula to leave a cell blank
    By dandavis1 in forum Excel General
    Replies: 6
    Last Post: 08-25-2009, 05:54 AM
  7. [SOLVED] Formula <0 leave cell blank
    By Whit in forum Excel General
    Replies: 3
    Last Post: 08-12-2006, 09:50 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