Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Blank Cell If Value Is Zero

  1. #1
    Join Date
    18th December 2006
    Location
    Brisbane, Australia
    Posts
    22

    Blank Cell If Value Is Zero

    Afternoon all

    I am looking for some help making the formula i am using appear blank if there is not yet values entered in the cells

    i am using =DATEDIF(A1,B1,"m")

    i am trying to find the difference between 2 dates in months but if the values have not been entered into the cells then it populates as zero? is there a way i can leave it blank

    Thanks heaps for your help

    Terri

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st December 2006
    Posts
    1,047

    Re: Blank Cell If Value Is Zero

    Hi Terri,

    Assuming the dates are in cells A1 & B1, use the following formula in your destination cell:

    =IF(OR(A1="",B1=""),"",DATEDIF(A1,B1,"m"))

    Kind regards,

    Robert
    : D

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    18th December 2006
    Location
    Brisbane, Australia
    Posts
    22

    Re: Blank Cell If Value Is Zero

    thanks so much your a life saver : D

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,467

    Re: Blank Cell If Value Is Zero

    You can also hide zeros from the Tools > Options > View menu
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  5. #5
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Blank Cell If Value Is Zero

    Quote Originally Posted by royUK
    You can also hide zeros from the Tools > Options > View menu
    If you do this, it is important to realise that the cell content will still be 0, not blank, so any tests for cell contents must still be for 0 - can be a bit confusing.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Blank Formula Cell To Empty Cell
    By mc_konazz in forum EXCEL HELP
    Replies: 2
    Last Post: February 26th, 2008, 08:48
  2. Replies: 15
    Last Post: July 12th, 2007, 18:07
  3. Replies: 2
    Last Post: March 24th, 2006, 21:06
  4. Formula Evaluate to Blank if Referenced Cell Blank
    By SomeoneHere in forum EXCEL HELP
    Replies: 6
    Last Post: October 28th, 2005, 06:42
  5. Replies: 3
    Last Post: October 8th, 2004, 08:11

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
  •  
porno