» 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:
- Accounting for Dummies
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- A Mathematician Plays the Stock Market
No comments have been submitted.
