Forum Discussion

Amat3ur's avatar
Amat3ur
Copper Contributor
Apr 26, 2019

How to SUM cells with ISBLANK=FALSE ''''

Dear all

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 !

Anto

 

Formulas and Functions

3 Replies

  • Amat3ur's avatar
    Amat3ur
    Copper Contributor
    Apr 26, 2019
    Thanks ! That was a mistake. Same formula for line 4 gives me 0. How can I have a BLANK cell instead
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Apr 26, 2019
      In that case, you may construct your formula in H3, this way:
      =IF((D3="")*(G3=""),
      "",
      SUM(D3,G3)
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 26, 2019
    Modify your formula in H3 from =SUM(D3+G3) to =SUM(D3,G3).

Resources