» 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:
- Special Edition Using Microsoft Office XP
- Harry Potter and the Order of the Phoenix (Book 5)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- PowerPoint® 2002 For Dummies®
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.
