455,639 views
0 votes
0 votes
How can you use the fraction in the first column to

write the equivalent decimal in the second column?

How can you use the fraction in the first column to write the equivalent decimal in-example-1
User Julien Alary
by
2.5k points

2 Answers

13 votes
13 votes

Answer: Create a lookup from the unusable fraction format to one that you can use in excel:

First column in the lookup should be the fraction in unusable format

Second column should be the fractions in a usable format, first format the cells in second column > Format Cells menu > Number tab > Category as Fraction > Type "Up to one digit (1/4)"

Manually in the corresponding cells the equivalent values (for example, below in cell H2 write 5/8)

Explanation:

User Rafael Fragoso
by
2.7k points
13 votes
13 votes

Answer:

Explanation:

Firstly you should times the first decimal of the column by the number that is the numerator. So the second column the numerator is 2 so you times the first number by 2 which gives you 0.10. You do this for every column then you get you answer.

User Muhamed Riyas M
by
2.9k points