# IF function failing to create blank due to formula

#### Glenjamin

##### New Member
Hi,

I'm working with formula

=IF(Finance2!D15<>"",Finance2!D14,"")

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.

Glen

Last edited:

#### JackDanIce

##### Well-known Member
Try:
Code:
``=IF(LEN(TRIM(Finance2!D15))>0,Finance2!D14,"")``

#### Glenjamin

##### New Member
Try:
Code:
``=IF(LEN(TRIM(Finance2!D15))>0,Finance2!D14,"")``
Thanks for that. I had to change the formula to =IF(LEN(TRIM(Finance2!D15))>4,Finance2!D14,""

I'm unsure why that alteration was required?

Cheers,

Glen

#### JackDanIce

##### Well-known Member
Without seeing your sheet, no idea I'm afraid, but glad you have it resolved

1,078,495
Messages
5,340,706
Members
399,390
Latest member
newexcel12

### 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...