From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

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

Working with the ROUND, ROUNDUP, and ROUNDDOWN functions

Working with the ROUND, ROUNDUP, and ROUNDDOWN functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Working with the ROUND, ROUNDUP, and ROUNDDOWN functions

“

- In this worksheet called BasicRounding we've got some items identified by item number in column C. A current price in column D. All of these items are going to have a price increase of 2.34 percent. And so there's a formula in column E, starting in E2, looking something like this. And so the new price of this first item is $9.00. Imagine these are office supplies. A large company orders 10,000 of these. Perhaps it's a box of 10's. So simple little formula here equal the cell that's got the 10,000 in it times the cell with the nine dollars in it and you know the answer. It's going to be 90,000, except that it isn't. And somebody has to account for this $43.14 here somehow. So what's really going on there? I'm going to click on cell E2 and on the Home tab in the Number group I'm going to increase the decimal display. And as I do this keep an eye on that amount in cell F2, that 89,000 number. As I increase the decimals in cell E2. Nothing is changing in cell F2. The real value of the…

Contents