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.

2 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.

Leave a Reply

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