Iam applying this Formula in cell D3:
=IF(ISBLANK(B3)=FALSE,ISBLANK(C3)=FALSE),SUM(-B3-C3+D2),"") ==> Answer is 1000
the same formula is applied in cells G9 (Answer is '''', meaning there is nothing to sum in cells E3, F3 and G2).
I want then in H3 to SUM (D9+G9) ==> Answer is #VALUE!
I want to have 1000 instead of #VALUE
As the Revenues for this year is 1000
Thanks a lot for your help !