CATEGORY: Excel Text, Editing and Format VERSIONS: All Microsoft Excel Versions

Problem: Rounding the prices in column A to the nearest nickel (5 cents), dime (10 cents), quarter (25 cents), and dollar. Solution: Use the ROUND function in the following formulas: Nearest Nickel Formula =ROUND(A2*20,0)/20 Nearest Dime Formula =ROUND(A2*10,0)/10 Nearest Quarter Formula =ROUND(A2*4,0)/4 Nearest Dollar Formula =ROUND(A2,0)

Rate this tip 1 2 3 4 5   RATING: 4.45   VIEWS: 10780 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses Microsoft Access 2002 for Dummies Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business Microsoft Word Version 2002 Step By Step (With CD-ROM)

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books