MS EXCEL series addition - Microsoft Community

dear all,

i want have addition formula in excel in following manner,

"first result in column f (f4)  = (b4*c4)+c4 from 

column  (f5) on wards want f5 = f4+d5, in series, successful in doing

but annoyingly next cells show result of previous cel

for example 69 in figure

how can rid of annoying 69 (in red colour) in series on wards? 

thanks & regards

tuhin

hello,

you can suppress zeros in column d wrapping formula in if statement , calculating when 2 cells in , b have been filled, example

=if(count(b5:c5)=2,b5*c5,"")

then can use same principle in column f. don't calculation if d5 blank.

=if(d5="","",e5+d5+f4)

Office / Excel / Windows 10 / Office 2016