Excel IF formula #value

[Martmorg]

Hi All,

I am having trouble with a formula and my excel formula knowledge is fairly basic. I have the below formula that i have come up with =IF(K7=0,"",(L6+K7)) however as the reference cell K7 also has a formula it is not picking this up as blank and showing a #VALUE ! error. Can anyone suggest an alternative formula please?

Thanks in advance

 

[Jonmo1]

What is the formula in K7?
What about L6?

 

[Martmorg]

What is the formula in K7?
What about L6?

L6 is a static formula. The formual i am getting the error is sitting in L7 and i would look to drag this down to provide a running YTD value.

K7 current has this formula =IF(I7=0,"",(I7*(J7/365)

 

[Jonmo1]

What do these test formulas return, enter them in any cell you choose.

=ISNUMBER(L6)
=ISNUMBER(K7)

 

[Martmorg]

Hi

=ISNUMBER(L6) is showing as True
=ISNUMBER(K7) is showing as False

 

[Jonmo1]

If the formula is returning "", that is NOT the same as 0.
Perhaps the formula
IF(K7=0,"",(L6+K7))
should be
IF(K7="","",(L6+K7))

 

[Martmorg]

If the formula is returning "", that is NOT the same as 0.
Perhaps the formula
IF(K7=0,"",(L6+K7))
should be
IF(K7="","",(L6+K7))

Thankyou that has worked perfectly.

Regards

Martin