If you don’t want to show decimal values in Excel, you can simplify your numerical data using the ROUND functions. Excel offers three functions: ROUND, ROUNDUP, and ROUNDDOWN. Let’s take a look at how they work.
Using the ROUND functions in Excel is different than changing the number’s format. When you change how a number is formatted, you’re just changing how it looks in your workbook. When you change a number using the ROUND functions, you’re changing how it looks and how it’s stored.
Comment