As an example, let’s say you sell fruit. At the end of the day, you sold 25 apples and collected $14.35. This averages out to 57.4¢ each. Obviously there is no such thing as .4 cents! Therefore you would need to ROUND that number. The ROUND formula takes the form of =ROUND(Number or calculation to round, Number of decimal places) Usually, anything dealing with currency or dollars, you will want to round it to 2 decimal places - unless you’re dealing with very large numbers and cents are insignificant; then you’ll want to round to 0 decimal places (dollars only; no cents).
Here’s our example:
And after applying the formula:
Once you are done, you can Copy & Paste Values or simply leave the formula as is. It’s up to you!
NOTE:
If you don’t use the ROUND formula and simply apply the currency formatting, or any other formatting that formats numbers to 2 decimal places; that is only formatting! You only SEE numbers out to 2 decimal places, but the data may still have more. Just keep that in mind when using that type of formatting.
Keep Excelling!
Do you like this post? Comment below and / or share on Facebook or Twitter!
