From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Using the CEILING and FLOOR functions for specialized rounding needs

Using the CEILING and FLOOR functions for specialized rounding needs - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using the CEILING and FLOOR functions for specialized rounding needs

“

- [Instructor] Excel has a variety of different rounding functions. The most common one is the functions called ROUND, but it also has two companions, ROUNDUP and ROUNDDOWN. But there will be times when they don't do exactly what we wish they could do. All three of those functions allow us to round data on the basis of the placement of decimals either to the right or to the left. In column C here, we got some formulas here. We're calculating new prices. Simple little formula like this. Taking the data in column B, increasing it by 2.34%, that's over in D1, and doing that for all these prices. Now if you were to write a formula here to multiply this by, let's say a big number, 10,000, you're going to be surprised at the answer. 10,000 times nine is 90,000, but what's going on there? What probably should've been done is when these calculations were made for column C probably comma format was used. Let's increase the decimals…

Contents