=(F2*0.4)+(G2*0.4)+(H2*0.2)

This formula works well for my needs; however, I want the final answer to be a rounded number with no decimal places. I need help to add the ROUND function in this formula. Thanks.

=(F2*0.4)+(G2*0.4)+(H2*0.2)

This formula works well for my needs; however, I want the final answer to be a rounded number with no decimal places. I need help to add the ROUND function in this formula. Thanks.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Hi there

Try

`=ROUND(SUM((F2*0.4)+(G2*0.4)+(H2*0.2)),0)`

The zero at the end specifies by how many decimal points to round to. You could also try the ROUNDDOWN or ROUNDUP function.

The above is ok, but what if you need to do this for more than 200 rows in the same spreadsheet