» Converting Decimal Fractions to Fractions of a Specified Number
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Converting the decimal fractions in List1 to fractions of four, where each quarter is the equivalent of one decimal unit (tenth).
Solution 1:
Use the INT function as shown in the following formula:
=INT(A2)+((A2-INT(A2))*4)/10
Solution 2:
Use the DOLLARFR function as shown in the following formula:
=DOLLARFR(A2,4)
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- Investing in Real Estate, Fourth Edition
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Harry Potter and the Order of the Phoenix (Book 5)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Word 2002: The Complete Reference
No comments have been submitted.
