IF and SUM not returning desired result

Please Login or Register  to view this content.

I have the above formula entered in a cell where c15 is the number of hours worked. The other cells contained numbers based on the number of items sold.

The desired result is obviously to have 0 returned if no hours have been worked, but it's returning #DIV/0

I know you can't divide by zero, that's why I have the IF, so I'm stumped as to what is wrong with the calculation.

Can anyone help?

You need to put the /C15 inside the IF function, i.e. move a parenthesis like this

=IF(C15=0,0,SUM(V15,T15,R15,P15,N15,L15,J15,H15, F15)/C15)

Originally Posted by daddylonglegs

You need to put the /C15 inside the IF function, i.e. move a parenthesis like this

=IF(C15=0,0,SUM(V15,T15,R15,P15,N15,L15,J15,H15, F15)/C15)

doh!! Of course, thank you.