How to make Excel 2007 Formulas Roundup



This tutorial will show you how to make a formula roundup in MS Excel

Don’t forget to check out our site for more free how-to videos!
– our feed
– join us on facebook
– our group in Google+

Often a formula will deliver a result that has a decimal place, this tutorial will show you how to make excel formulas roundup to prevent this issue.

Step # 1 — Using Just the SUM Formula

First off, load a spreadsheet that has some data in it. In this example we are going to be adding the price figures in column “B” of this sheet together. If we use the sum formula here we are left with “61.66”, we want this number to automatically round up to “62”.

Step # 2 — Entering the SUM and ROUNDUP Formulas Together

Fortunately Excel comes with a formula that you can use in conjunction with others to make the result round up. This formula is known as the “ROUNDUP” formula. To use this first delete the SUM formula already entered, here it’s in cell “B5”. Now click on this cell and type, “=ROUNDUP(SUM(“. Now click and drag to highlight all of the numerical values you want to add together. Next type “),0)”.

Step # 3 — Completing the Process

Press return and the formula will be applied. You will see here that the formula now rounds up the SUM result to “62”. That is how to make excel formulas roundup and the ROUNDUP formula can be used for many other formulas besides SUM.

Nguồn: https://mechoimages.com/

Xem thêm bài viết khác: https://mechoimages.com/tong-hop/


Article Categories:
Tổng Hợp

Comments

  • ❗ Subscribe To Our Main YouTube Channel

    https://www.youtube.com/user/howtechpc

    Excel, Word and PowerPoint Tutorials from Howtech June 25, 2020 2:48 am Reply
  • THANKS BROTHER!

    Renzo Cresci June 25, 2020 2:48 am Reply
  • ja hulde 62!

    bestuur W.S.G Isaac Newton June 25, 2020 2:48 am Reply
  • Thank you for making this easy to understand.

    Wise Photographics / Clare Wise de Wet June 25, 2020 2:48 am Reply
  • I need round up the result from this formula =B18*8*0,0333+B18 i tried =ROUNDUP(B18*8*0,0333+B18),1), I want 1 decimal) and i tried =ROUNDUP(=B18*8*0,0333+B18),1) That doesnt work. Can you help? =)

    Oscar .Throedsson June 25, 2020 2:48 am Reply
  • Thanks

    DesignReady June 25, 2020 2:48 am Reply
  • very helpful… thank you so much

    GSSS Riali Kalan June 25, 2020 2:48 am Reply
  • Thanks this is what i needed…was driving myself crazy trying to remember what was missing from my formula. Holding where the formula shows for a little longer would be helpful. 🙂

    Brenda Schuett June 25, 2020 2:48 am Reply
  • Thanks!

    Nikita Alexander June 25, 2020 2:48 am Reply
  • You're too slow! Pick up the pace!!!If you just started at the 0:48 mark, that's all people need when searching for this.

    Doctor Doom June 25, 2020 2:48 am Reply
  • thank you man,like my ict cambridge examis after a week and you teach me how to do it

    kareem mohamed June 25, 2020 2:48 am Reply

Leave a Comment

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