Using rounding shortcuts

- In this worksheet called Rounding…we've got a calculation in C2…that's coming up with a new price.…Each of these items are going to have a price increase.…They're all going to have a price increase of 2.65%…so I've got a formula down here,…it looks rather ordinary, we're going to be…copying it down the column.…But just to check it out we might…set up a little formula to the right.…Somebody orders 10,000 of these,…maybe its a office equipment box of pencils,…something like that.…Equal 10,000 times this eight dollars right here.…We know it's going to be 80,000 dollars.…But it's not.…

And somebody has to account for that…what, 35 dollars and 65 cents there.…What's really going on here?…Calculation looks okay.…After a while it's pretty apparent,…this is not really eight dollars.…If you're working with numbers that involve decimals,…could be scientific data, in this case currency type data,…don't make the mistake of misusing these buttons…by thinking that they actually change results.…Whoever wrote the formula probably…