1 Reply Latest reply on Dec 21, 2012 9:54 AM by The King of Milk2

    Help with rule

    The King of Milk2

      Here is a rule I need to enter when I am conducting my calculations. I want to know if anyone can help me input the rule. The rule is "When rounding off to the nearest whole number, round to the nearest even number when the value ends in .5, when rounding to the nearest tenth, round to the nearest even tenth when the value ends in .05. This same principle applies to rounding off to the nearest ten and to the nearest thousand." Pretty much this is what it means. Not trying to insult anyone that is out there. 16.5 = 16; 17.45 = 17.4; 17.451 = 17.5. Anyone that can help me with this would be much appreciated. Thank you!

        • 1. Re: Help with rule
          The King of Milk2 Level 1

          =IF(SUM(B14:B15)/2=0,"",Bround((SUM(B14:B15)/2),0))   hopefully this may help. This is what the formula looks like in excel. I have tried working with it but still getting a lot of errors. Still any help would be great. Also, not sure how it works. But using the help, I got this answer "

          However, the IEEE 754 standard dictates that the number literal 0.045 be approximated to 0.0449999999999999. This approximation is closer to 0.04 than to 0.05. Therefore,

              Round(0.045, 2)    

          returns 0.04"

          Something using number literals.