IF function failing to create blank due to formula

Glenjamin

New Member
Joined
Sep 30, 2014
Messages
9
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
Joined
Feb 3, 2010
Messages
9,312
Without seeing your sheet, no idea I'm afraid, but glad you have it resolved :)
 

Forum statistics

Threads
1,077,617
Messages
5,335,260
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top