» Rounding Numbers that Meet Specified Criteria
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Rounding all the numbers in column A to zero decimal places, except for those that have "5" in the first decimal place.
Solution:
Use the IF, MOD, and ROUND functions in the following formula:
=IF(MOD(A2,1)=0.5,A2,ROUND(A2,0))
Book Store:
Recommended Books:
- Analysis of Financial Statements
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Monte Carlo Methods in Finance
- Getting to Yes: Negotiating Agreement Without Giving In
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Learn MS Excel 2002 VBA/XML Programming
No comments have been submitted.
