iPad numbers formula

Question

iPad numbers formula

The “ + “-fotmula sometimes renders faulty results. See screenshot with exact coordinates, well determinared cells and wrong result.

[Re-Titled by Moderator]

iPad

Posted on Jan 11, 2024 1:26 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,684 points

Jan 12, 2024 8:56 AM in response to walter Van Geyt

I can't spot where things may have gone wrong. Your formula seems to capture just the -524,78 -25,00 and -105,00.

It looks as if you might have merged some cells at some point (I see no border, for example, in rows 68:70 for columns A and B). Merging can cause strange behavior in some calculations. I suggest unmerging any merged cells in the table, reentering the values in B63:B70 and reentering the SUM formula in D70.

SG

Reply

Answer 2

SGIII

Level 8

37,684 points

Jan 12, 2024 7:17 PM in response to walter Van Geyt

I generally avoid merged cells wherever I can.

Have you tried reentering the data in B63:B70 and the SUM formula?

If the data in B63:B70 comes from formulas referring to other cells then you might want to check those cells to make sure they are all Numbers.

SG

Reply

Answer 3

Jan 16, 2024 12:49 PM in response to walter Van Geyt

I finally found the answer . The error was caused by the formatting of the figures in B as you can see when comparing the foto’s. Separating the thousants by point, or komma…There seems to be really a fault in the programme. Many thanks for your interest. Walter

Reply

Answer 4

Jan 12, 2024 1:50 PM in response to SGIII

Thanks. I checked and found all the cells in rows and columns A and B split. ..or do you advise to check the whole sheet on merged cells?

Reply

iPad numbers formula

Similar questions