Excel - Formula to multiply time and sum up all them -

illustrative:

i need to:

• multiply d-column 10;
• multiply e-column 15;
• multiply f-column 20;
• and resulting times.

i've got this:

=((e3*10)+(f3*15)+(g3*20))/60 

but displays fractional number or 0 when there nothing on columns.

how can display result rounded when needed , hide when zero?

thanks in advance.

your formula doesn't quite match image. believe should be:

=((d3*10) + (e3 * 15) + (f3 * 20))/60 

to hide use if statement:

=if(((d3*10) + (e3 * 15) + (f3 * 20))/60 = 0,"",((d3*10) + (e3 * 15) + (f3 * 20))/60) 

though add hidden column (d) in , put formula rounding in there then 1 place change 9should need @ later date):

=round(((d3*10)+(e3*15)+(fg3*20))/60,0) 

with column c containing if statement:

=if(d3 = 0,"",d3)

alternatively - avoid if statement

you hide 0 values on sheet:

• click file tab, click options, , click advanced category.
• under display options worksheet, select worksheet, , deselect show 0 in cells have 0 value check box

.