» 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:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Understanding Financial Statements
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Writing Excel Macros with VBA, 2nd Edition
- Guide to Financial Reporting and Analysis
- The Basics of Finance: Financial Tools for Non Financial Managers
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
