From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use rounding shortcuts

Use rounding shortcuts

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Use rounding shortcuts

“

- [Voiceover] There are many times when you work with formulas that you need to consider the effects of rounding or not rounding. In this worksheet here, we've got some items listed by item number in column A, some prices in column B, and we've got a formula here that's calculating a new price, based on a 2.72% increase over in cell E1. So here's a simple formula, gets the job done, and we see the other prices. Now, let's take a simple example here. Somebody orders 10,000 of these. Maybe it's some kind of office equipment or something. This times 10,000, and you know the answer right away, don't you? It's 70,000, except it isn't 70,000, and somebody has to account for this. What is it? $47.68 there. What's happened to that, and why is this happening? In situations where you've got certain kinds of formulas, consider, at least temporarily, making display of the decimals different. Now, a serious mistake that some people make in Excel is they use these two buttons here, thinking that…

Contents