» Rounding Numerical Substrings
CATEGORY - Excel Financial Formulas
VERSION - All Microsoft Excel Versions
Rounding the numbers in the string stored in cell A2 (12.34567<>3.4567) to 3 decimal places.
Solution:
Use the ROUND, LEFT, FIND, and MID functions in the following formula:
=ROUND(LEFT(A2,FIND("<>",A2)-1),3)&"<>"&ROUND(MID(A2,FIND("<>",A2)+2,255),3)
Book Store:
Recommended Books:
- Investing for Dummies, Third Edition
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Wall Street Journal Guide to Understanding Money and Investing
- Yes, You Can Time the Market!
- Dictionary of Finance and Investment Terms
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
No comments have been submitted.
