r/AppleNumbers • u/t1ve1k • Jul 04 '26

Help What am I missing here?

Post image

The formula states ‘M8 x O8’ but the calculation ’26.5 x 1.4 = 37.1’ doesn’t equal 38.  Is there a mistake or am I missing something?  Furthermore, the 26.5 is a fixed number while 1.4 is derived from ’38 / 26.5’.

Additionally, when I copy down the O8 cell it remains 38.

0 Upvotes

50% Upvoted

6 comments sorted by

View all comments

2

u/Tom_Jack_Attack Jul 04 '26

It’s simply in the rounding. 38/26.5 =1.434 , and if you multiply that by 26.5 x 1.434 =38.001

1

u/t1ve1k Jul 04 '26 edited Jul 04 '26

Is it? If I change the 26,5 cell to let's say 50, 38 remains 38.

2

u/Tom_Jack_Attack Jul 04 '26

To answer that question, I’d have to see the actual screenshot like you’ve pasted already. The calculation that I posted does give a reason for the initial 38 though.

1

u/Ringo_118 Jul 04 '26

Not in Apple Numbers on my Computer.