Results 1 to 3 of 3

Perform calculation only when a certain date is reached

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    13

    Perform calculation only when a certain date is reached

    Hi,

    I currently have a formula in F12 that sums cells F4:F11
    In F13 I have a formula that checks if any cell between F4:F11 are blank, it won't calculate F12-30, and will leave the figure as 0

    =IF(COUNTBLANK(F4:F11)>0,0,SUM(F12-30))

    Essentially, the -30 is only calculated on the date at F1 (in this case 11/05/2013 Australian format as DD/MM/YYY)

    If there a way that I can keep the above formula, but also add in a date requirement?

    Example: IF F4:F11 are blank, AND TODAY()<F1, display 0, else sum F12-30

    I have tried =IF(AND(COUNTBLANK(F4:F11)>0,TODAY()<F1,0,SUM(F12-30))) but I get a "#N/A - wrong number of arguments to IF" error

    Kindes regards
    Last edited by Juleskor; 05-07-2013 at 08:17 PM. Reason: wrong cell at -30 calculation. Changed from E12 to F12

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