Monday, 5 August 2013

Rounding Numbers

By , Director, Naturally Sales Ltd.


Excel has a number of ways to round numbers. Today we'll look at three of these methods, and we'll re-visit the topic in a future edition.

The first we'll look at is the ROUND function. This rounds a decimal to the number of digits specified, and is constructed as follows: =ROUND(number, no. of decimals). For example, =ROUND(3.141592654,3) would give 3.142. Remember, of course, that these numbers don't have to be built into the formulas - they can be cell references containing numbers instead.

Maybe, though, you specifically want to round up or down. The formulas for these are constructed in the same way. The ROUNDUP function will round up to the number of decimals specified and ROUNDDOWN will round down in the same way.

As always, if you'd like further help with these, send an email to excel-help@nsales.co.uk and we'll get back to you.

1 comment:

  1. Gambling on-line or in particular person turns into problematic when the particular person has no control over the time and money they spend on video games. In different phrases, the participant turns into managed by compulsions to gamble regardless of exterior elements, similar to 온라인카지노 a depleting checking account. Some players try to money in on the identical on line casino bonus greater than once as} by creating several of} accounts. This practice isn't allowed and can get you removed from on-line casinos. If you’re on the lookout for on-line casinos with bingo, we suggest PlayOJO. This site has tons of of bingo video games to choose from|to choose from}, so you’re certain to find a recreation that fits your preferences.

    ReplyDelete