IF function failing to create blank due to formula


New Member

I'm working with formula


So if there is data in D15 (Column actual) , D14 (target) value is used. If not it remains blank. Its basically creating a cumulative total as row 15 has a target every month already entered for the year, so the cell i have this typed in to will remain blank until such times as the next actual is typed in.

I have this working for the whole document bar this one particular sheet. The reason I believe it is working in other cases is the data being pulled is being typed in the other sheets. In this finance2 doc the data here is being pulled from a separate workbook. This appears to be making cell D15 appear to always have data in it even though the cell itself is blank, as obviously it has a formula linking to another workbook? This means the cumulative total is filling in for the whole year even though visually the 'actual' cell is empty.

Any help would be much appreciated.

Last edited:

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...