Do not calculate formula if there are blank cells

[himderfella]

My absence has been a while. Currently I am attempting to calculate a value using Deposit amount & Expense amount columns with result in column E. Formula =SUM(E20-D21+C21) & it works in part. When I copy the formula down column E it shows the correct result which is the last value in column E (Account Balance).
But I need it to show blank (the worksheet has been changed to not show zeros) if values in both columns C & D are blank & without carrying forward the last value in column E.
My efforts using ISBLANK & IFBLANK have drawn a blank.
Any assistance is much appreciated.
Merry Christmas & A Happy & healthy New Year.
Cheers
Chris

 

[SanjayGMusafir]

My efforts using ISBLANK & IFBLANK have drawn a blank.

ISBlank work if cell has nothing

Try Using for eg. E20="" for the purpose and revert

 

[MARK858]

Do you mean something like

=IF(AND(C22="",D22=""),"",SUM(E20-D21+C21))

or

=IF(AND(C22="",D22=""),"",E20-D21+C21)

P.S.
If you can, please use the boards XL2BB to post screenshots rather than images as we can't copy them into Excel and most won't retype your data

 

[himderfella]

Thanks Mark858 your second formula worked a treat. Thanks very much. Cheers Chris

 

[MARK858]

You're welcome