No Links were listed yet. Go ahead and share!
Hey, welcome back to the Mr. Excel net cast. I'm Bill Jelen. We start out with mass of amounts of data, and how we're going to analyze this? Well, let's fire up the pivot table and to solve this problem.
Hey, welcome back for another Mr. Excel podcast, I'm Bill Jelen. Question sent in today by Michael is kind of - sort of related to rounding, I'm going to format all these cells here as currency with a couple of decimal places. So I’ll just choose currency and then Michael puts in a formula here, that’ll be for one dollar divided by three and you see of course we get 33 cents all the way down, adds it up and wonders why he’s not getting 99 cents.
Okay well, I mean Excel is really storing that not as .33 but as point .333333 and if you want this to add to 99 cents, I have a couple of options for you. Option number one, let’s copy this over, option number one here is do not enter a dollar divided by three would actually use the round functions. I want round of one divided by three comma, two, another one is two digits after the decimal place. Then we get 99 cents or another option to go is to go in Excel options, and we’ll go to the advance tab and then scroll all the way down here for—when calculating this workbook, set precision as displayed. I mean if we’re only showing two decimal places, only calculate after two decimal places.
Big warning there, data will permanently lose accuracy in the whole workbook. Be careful before you do this, it’s going to cut things off everywhere. Click okay, click okay, and now we get 33, 33, 33 is 99. So a couple of options there, I’m always afraid of the set precision as displayed, it might be easier to use the round function in order to work that out. A couple of different ways to go, I want to thank you for stopping by. We’ll see you next time for another netcast from Mr. Excel.
Well thanks for stopping, we’ll see you next time for another netcast on Mr. Excel.
Transcription by:
Scribe4you Transcription Services