{"id":3829,"date":"2015-03-23T22:02:10","date_gmt":"2015-03-23T21:02:10","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=3829"},"modified":"2020-09-04T09:40:25","modified_gmt":"2020-09-04T07:40:25","slug":"funkce-pro-zaokrouhleni","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/funkce-pro-zaokrouhleni\/","title":{"rendered":"Functions for rounding"},"content":{"rendered":"

<\/p>\n

For calculations in Excel can be often assumed difference between the format\u00a0of the result and the real\u00a0value rounded. In this tutorial you will learn how solve\u00a0this problem and learn practical function to correct round. If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

Format vs. real result<\/h2>\n

Imagine that in the table comes from the formula result 3.646. If you format the result eg. to display 2 decimal places (menu Format Cells> Number) then appears in cell number 3.65. But the real\u00a0value does not change with the format, we can look in the formula bar. If we then multiply this cell 1000 *, the result will be\u00a03646. If we use a calculator, multiply 3.65 x 1000, result will be\u00a03650. We see the difference between the values 4, and sometimes, even if seemingly small difference, have a major impact.<\/p>\n

Conclusion: Format Cells does not change a real\u00a0value of the cell, with which other formulas count.<\/strong><\/p>\n

The following functions change\u00a0the real\u00a0value for further calculations.<\/p>\n

\"Funkce<\/a>
Round functions (czech)<\/figcaption><\/figure>\n

Function ROUND<\/h2>\n

=ROUND(number, num_digits)<\/p>\n

    \n
  • number\u00a0… numerical value or cell to be rounded<\/li>\n
  • num_digits\u00a0… indicates the number of decimal places<\/li>\n<\/ul>\n

    This function rounded as in mathematics, ie. 5 always at a higher number, up to 5 at a lower number.<\/p>\n

    Function ROUNDUP<\/h2>\n

    =ROUNDUP(number, num_digits)<\/p>\n

      \n
    • number\u00a0… numerical value or cell to be rounded<\/li>\n
    • num_digits\u00a0… indicates the number of decimal places<\/li>\n<\/ul>\n

      This function is always rounded\u00a0up<\/span> to the higher\u00a0number.<\/p>\n

      Function ROUNDDOWN<\/h2>\n

      =ROUNDDOWN(number, num_digits)<\/p>\n

        \n
      • number\u00a0… numerical value or cell to be rounded<\/li>\n
      • num_digits\u00a0… indicates the number of decimal places<\/li>\n<\/ul>\n

        This function is always rounded\u00a0down<\/span>\u00a0to the lower\u00a0number.<\/p>\n

        Function TRUNC<\/h2>\n

        =TRUNC(number; num_digits)<\/p>\n

          \n
        • number\u00a0… numerical value or cell to be rounded<\/li>\n
        • num_digits\u00a0… indicates the number of decimal places, if omitted it removes all decimal places<\/li>\n<\/ul>\n

          This function is always “cut off” all from the numbers after\u00a0specified decimal places.<\/p>\n

          Function INT<\/h2>\n

          =INT(number)<\/p>\n

            \n
          • number\u00a0… numerical value or cell to be rounded<\/li>\n<\/ul>\n

            This function always rounded\u00a0down to the nearest integer.<\/p>\n

            Function FLOOR<\/h2>\n

            =FLOOR(number, significance)<\/p>\n

              \n
            • number … numerical value or cell to be rounded<\/li>\n
            • significance … indicates the unit \/ multiple to which number will be\u00a0rounded up<\/li>\n<\/ul>\n

              This function is always rounded\u00a0down\u00a0to a given multiple. If we want to round to an integer set argument significance with a value of 1, to tens set 10, to hundreds set 100, to tenths 0,1 etc.<\/p>\n

              Similarly works CEILING function which always rounded up\u00a0to the given multiple.<\/p>\n

              In version 2013, these functions are replaced by functions CEILING.MATH a FLOOR.MATH, but still remain supported.<\/em><\/p>\n

              <\/p>\n","protected":false},"excerpt":{"rendered":"

              For calculations in Excel can be often assumed difference between the format\u00a0of the result and the real\u00a0value rounded. In this tutorial you will learn how solve\u00a0this problem and learn practical function to correct round. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it\u00a0can be useful […]<\/p>\n","protected":false},"author":1,"featured_media":3840,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,49,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/3829"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=3829"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/3829\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/3840"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=3829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=3829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=3829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}