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)
Bookmarks