+ Reply to Thread
Results 1 to 2 of 2

Calculate unless blank

  1. #1
    Registered User
    Join Date
    02-24-2010
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2003
    Posts
    51

    Calculate unless blank

    Currently if the date of 2/16/2010 is entered into cell N4, my formula will take the date (mmddyyyy) and display in it's resident cell as 2010-Q1.

    My formula:
    =YEAR(N4)&"-Q"&INT((MONTH(N4)+2)/3)

    Question:
    What formula could I use that said, if blank, do nothing. If date, then my formula?

    Any help is greatly appreciated.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,601

    Re: Help with using a formula that will calculate unless blank.

    Try =IF(A1="","",formula)

+ 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