ROUNDUP every medical practice manager you know to watch Excel Video 190. Many of you may be familiar with the ROUND function in Excel. The syntax is simply =ROUND(number you want to round, number of digits to round to). If the number of digits is 0, Excel rounds to the nearest integer. If the number of digits is positive, Excel rounds that many digits to the right of the decimal. For example, ROUND(5.421,2) equals 5.42. If the number of digits is a negative number, Excel rounds that many digits from the left of the decimal. For example, ROUND(8432.19,2) equals 8400.
You’ll also see two more rounding functions in Excel Video 190, ROUNDUP and ROUNDDOWN. Both have the same syntax as ROUND does. ROUNDUP always rounds up to the precision set by number of digits. ROUNDDOWN always rounds down to the precision set by number of digits. You’ll see examples of both in the video.
Stay tuned. Next time we’ll cover three lesser used functions. The cool thing is when you put the lesser used functions together, you can convert minutes to hours:minutes. I look forward to seeing you then.
