From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Overcoming rounding concerns in formulas with functions and decimal displays

Overcoming rounding concerns in formulas with functions and decimal displays - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Overcoming rounding concerns in formulas with functions and decimal displays

“

- [Instructor] A not uncommon mistake in Excel 2 is to use two buttons in the Number group on the Home tab, 3 Increase Decimals, Decrease Decimals. 4 Sometimes people use these 5 thinking that they are changing values. 6 These only change appearance. 7 It has relevance when we're dealing 8 with certain kinds of calculation. 9 We've got some current prices in column B 10 for these items here, 11 and we're calculating a new price for each one of them 12 based on a 5.8% increase. 13 We see that in cell E2. 14 So a calculation in C2 here seemingly makes sense. 15 Simple formula. 16 One of a number of different ways 17 to come up with the answer. 18 And imagine, this might be office equipment here, 19 somebody orders a thousand of these, 20 maybe a box of pencils or something. 21 And you probably know ahead of time, 22 if you take a thousand, 23 we'll just do this one manually, 24 times this amount, 25 it's…

Contents