IF function failing to create blank due to formula


New Member
Sep 30, 2014

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:


Well-known Member
Feb 3, 2010
Without seeing your sheet, no idea I'm afraid, but glad you have it resolved :)

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...