How do I add the ROUND function to an existing formula?

=(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.

18 thoughts on “How do I add the ROUND function to an existing formula?

  1. Excel Geek

    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.

  2. ekonomski

    Real good info can be found on website. Even if happiness forgets you a little bit, never completely forget about it. by Donald Robert Perry Marquis.

Leave a Reply

Your email address will not be published. Required fields are marked *