+ Reply to Thread
Results 1 to 10 of 10

Keep cell blank or with 0:00 value

  1. 10-24-2022, 04:10 AM #1
    doe2
    doe2 is offline
    Registered User
    Join Date
    10-22-2022
    Location
    Sarajevo, Bosnia
    MS-Off Ver
    19
    Posts
    9

    Keep cell blank or with 0:00 value

    Hello,
    I have a cell D4 which calculates time from other two cells where default value is 7.5. And when I want to reference this cell it keeps showing value 7,5 even no data is entered in its referenced cells.
    This is the formula that calculates data from cell D4 and would like to keep it blank or 0:00.
    =IF(D4<7,5/24;7,5/24-D4;0)

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 10-24-2022, 04:20 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Keep cell blank or with 0:00 value

    Try:
    =IF(D4="";"";(D4<7,5/24;7,5/24-D4;0))
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 10-24-2022, 04:26 AM #3
    doe2
    doe2 is offline
    Registered User
    Join Date
    10-22-2022
    Location
    Sarajevo, Bosnia
    MS-Off Ver
    19
    Posts
    9

    Re: Keep cell blank or with 0:00 value

    Thanks Glenn,
    but getting error "There is problem with this formula..."
    Reply With QuoteRegister To Reply
  4. 10-24-2022, 04:47 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Keep cell blank or with 0:00 value

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Reply With QuoteRegister To Reply
  5. 10-24-2022, 04:47 AM #5
    AliGW
    AliGW is offline
    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,830

    Re: Keep cell blank or with 0:00 value

    Try this:

    =IF(D4="","",(D4<7.5/24,7.5/24-D4,0))
    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
  6. 10-24-2022, 04:53 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Keep cell blank or with 0:00 value

    Ooops.

    =IF(D4="";"";if(D4<7,5/24;7,5/24-D4;0))
    Reply With QuoteRegister To Reply
  7. 10-24-2022, 04:57 AM #7
    doe2
    doe2 is offline
    Registered User
    Join Date
    10-22-2022
    Location
    Sarajevo, Bosnia
    MS-Off Ver
    19
    Posts
    9

    Re: Keep cell blank or with 0:00 value

    Thanks...ahhh that "if" in right place...
    Reply With QuoteRegister To Reply
  8. 10-24-2022, 04:59 AM #8
    doe2
    doe2 is offline
    Registered User
    Join Date
    10-22-2022
    Location
    Sarajevo, Bosnia
    MS-Off Ver
    19
    Posts
    9

    Re: Keep cell blank or with 0:00 value

    Thank you for your effort.
    It needed "IF" like Glen posted...
    Reply With QuoteRegister To Reply
  9. 10-24-2022, 04:59 AM #9
    doe2
    doe2 is offline
    Registered User
    Join Date
    10-22-2022
    Location
    Sarajevo, Bosnia
    MS-Off Ver
    19
    Posts
    9

    Re: Keep cell blank or with 0:00 value

    my fault...
    Reply With QuoteRegister To Reply
  10. 10-24-2022, 05:00 AM #10
    AliGW
    AliGW is offline
    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,830

    Re: Keep cell blank or with 0:00 value

    Please mark as solved, as advised in your previous thread.
    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] IF Cell is blank, calculate, if cell isn't blank, leave blank
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2015, 03:54 PM
  2. [SOLVED] Populate Text in Cell based on blank/non-blank status of other cell(s)
    By cmkarnes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2015, 06:53 AM
  3. Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2014, 11:31 PM
  4. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  5. reference cell should be blank not 00-jan-00 how make it read like the blank cell (Blank )
    By mrjackt in forum Excel General
    Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  6. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  7. If cell blank OR another cell blank then show blank, if not display value
    By stevop622 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2013, 04:07 AM

Tags for this Thread

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