Return Blank

[Bedford]

Hoping for a solution. I'm using this formula, =IFERROR(Q981+$N$4,0) to add contents of N4 to Q981 in destination cell O981, but if Q981 is empty, O981 returns the value from N4. How can I stop O981 from returning a value if Q981 is empty.
Thank you in advance.

 

[Peter_SSs]

Is this what you mean?

=IF(Q981="","",IFERROR(Q981+$N$4,0))

 

[Bedford]

Is this what you mean?

=IF(Q981="","",IFERROR(Q981+$N$4,0))

Hi Peter, I gave it a shot, but it continues to return only the value from N4 if Q981 is empty?

 

[Sufiyan97]

Try

=IF(Q981="","",Q981+$N$4)

 

[Fluff]

it continues to return only the value from N4 if Q981 is empty?

That suggests that Q981 isn't actually empty, so what is in it?

 

[Bedford]

That suggests that Q981 isn't actually empty, so what is in it?

True enough, it has it's own formula; =V981*$Q$4, I did fail to mention that. However when Q981 doesn't return the result of the formula due to the precedent cell V981 being empty, it returns the value in N4. I'm hoping to get to a point where it remains blank when the resulting formula in Q981 is likewise blank due to V981 being empty.
A bit of a dog chasing it's tail?

 

[Fluff]

In that case try

=IF(Q981=0,"",IFERROR(Q981+$N$4,0))

or

=IF(V981="","",IFERROR(Q981+$N$4,0))

 

[Bedford]

In that case try

=IF(Q981=0,"",IFERROR(Q981+$N$4,0))

or

=IF(V981="","",IFERROR(Q981+$N$4,0))

Excellent! The first one works, the second one using the V981 doesn't work, thank you very much for your assistance.

 

[Fluff]

Glad we could help & thanks for the feedback