if-statement: EXCEL - incorporating ROUND to IF statement

vendredi 6 mars 2015

Current formula looks like


=IF(B4>0,(((B4-B5)/2)+B5)+B7+IF(E8>0,E8)+IF(B8="yes",B7)+B9," ")

I need the number to round to the nearest +.0625

I thought I could do


=IF(B4>0,(ROUND(((B4-B5)/2)+B5)+B7+IF(E8>0,E8)+IF(B8="yes",B7)+B9),.0625)," ")

but i get an error saying that I've entered too few arguments for the function and after clicking ok it highlights the B5.

Any suggestions?

if-statement