+ Reply to Thread
Results 1 to 5 of 5

If isblank

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    dublin
    MS-Off Ver
    Excel 2003
    Posts
    6

    If isblank

    I have three columns a, b and c. I'm applying the formula =IF(ISNUMBER(B5+A5),DAY(B5) & "/" & MONTH(B5) & "/" & YEAR(B5),"") to take out the hrs, mins, sec component of the date and place it in column C.
    I only want to publish the date in the Column C that has numerical values in Column A but 0/1/1900 is published in Column C when null values are encountered in column a.

    I was looking into using OR IF(OR(ISBLANK(A)) but I can't get this to work with my formula.

    Would anyone be able to help. Excel Book attached.
    Attached Files Attached Files

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: If isblank

    In C5:

    =IF(A5="","",IF(ISNUMBER(B5+A5),DAY(B5) & "/" & MONTH(B5) & "/" & YEAR(B5),""))

    Copy down.
    If someone helped give them rep using the star button.

    If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: If isblank

    Could you not just wrap an =IF(ISBLANK("reference");"your formula";"") around your formula?

    Or what darknation says.
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  4. #4
    Registered User
    Join Date
    03-28-2012
    Location
    dublin
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: If isblank

    Thanks for the help. That has done the trick.

  5. #5
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: If isblank

    Soren's formula is a bit cleaner.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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