Adding fractions / eights

Question

Level 1

4 points

Adding fractions / eights

Hello,

I was just wondering if I could get some help on this one. I have a bunch of values which I need to add in eights. Unfortunatly numbers is giving me the wrong answers, seemingly because it is treating them as decimals sometimes and fractions other times.

When I enter the numbers, I enter them as decimals, so 1.5 equals 1 4/8.

However 0.2 and 0.3 are both considered to be 2/8.

When I add the numbers up, over a large range this turns into a bit of a discrepency.

At the moment I have:

As Fraction	As Decimal
1 4/8	1.5
2 4/8	2.5
2/8	0.2
2/8	0.3
2/8	0.3
2/8	0.3

This should be Five, but using the sum fuction returns 5 1/8.

Is there anyway I can improve the accuracy?

iPad, iOS 5.1

Posted on Aug 4, 2016 12:24 PM

Reply

Answer 1

turingtest2

Level 10

278,297 points

Aug 4, 2016 2:17 PM in response to Reddkryten

I manged to do this in Numbers on iCloud entering the following values.

Fraction	Became
1 4/8	1 1/2
2 4/8	2 1/2
0 2/8	1/4
0 2/8	1/4
0 2/8	1/4
0 2/8	1/4
Sum	5

The sum showed reasonable results as I entered the values one at a time. 1/8 is 0.125 in decimal, so you need at least 3 decimal places of accuracy/display if you want to enter decimals. An alternative is to enter only the number of eighths in each cell, sum all of the digits, and then divide by eight at the end. (Without the leading zero numbers wanted to treat 2/8 as a date.)

tt2

Reply

Answer 2

SGIII

Level 8

37,568 points

Aug 16, 2016 6:29 AM in response to Reddkryten

Reddkryten wrote:

Is there anyway I can improve the accuracy?

In Numbers for iOS you have some control over accuracy displayed this way.

Tap the cell with the fraction
Tap the format "paintbrush"
Tap the 'Format' tab
Tap the circled i next to Number
Tap the 'Fraction' tab
Select the accuracy you want to display.

SG

Reply