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...
Formulas and Functions
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)

Resources