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

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

SaVsaq Some times its a pain in the ass to read what blog owners wrote but this site is very user genial!.

mOGXnh Very good article post.Really thank you! Want more.

This awesome blog is without a doubt entertaining and also factual. I have discovered a lot of useful advices out of this blog. I ad love to come back every once in a while. Thanks a lot!

Way cool! Some extremely valid points! I appreciate you penning this article and also the rest of the website is extremely good.

Thanks a lot for the blog.Much thanks again. Great.

Thanks for sharing, this is a fantastic blog article.Really looking forward to read more. Great.

I signed up to your blog RSS. Will you post more about this subject?

Read, of course, far from my topic. But still, we can work together. How do you feel about trust management?!

Of course, what a fantastic blog and illuminating posts, I definitely will bookmark your site.Best Regards!

Wow! Thank you! I continuously needed to write on my blog something like that. Can I take a part of your post to my website?

I’аve recently started a blog, the info you provide on this website has helped me tremendously. Thanks for all of your time & work.

This will be a great web site, might you be involved in doing an interview regarding how you developed it? If so e-mail me!

Pretty! This has been a really wonderful article. Thank you for providing this info.

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.

Very good blog post. I certainly appreciate this site. Stick with it!

Merely wanna say that this is handy , Thanks for taking your time to write this.