In '=quotient((sum(j18:p18 ~4); I have removed & replaced the TILDA many times.

The prgm puts it back … WHY?

And, could this cause Err 502 [invalid argument?

Thanks …

In '=quotient((sum(j18:p18 ~4); I have removed & replaced the TILDA many times.

The prgm puts it back … WHY?

And, could this cause Err 502 [invalid argument?

Thanks …

What about the closing bracket after `P18`

? I mean `=QUOTIENT(SUM(J18:P18);4)`

Quoting @abi: “…replaced the TILDA many times…”

By what?

(If you do many times exactly the same with a software, it should answer many times in exactly the same way. That’s what we expet ordinary software to do.)

Quoting @abi: “And, could this cause Err 502 [invalid argument?”

Yes. of course! (What’s the orphaned `[`

meant to mean?)

From the help:

`502`

`Invalid argument Function argument is not valid.`

`For example, ...`

Quoting @Lupp from Calc: formula: why are tildes auto-replacing commas?

The tilde is (as @pierre-ives samyn states correctly) the union operator for ranges in syntactically correct expressions. It is, however, also a kind of error marker in cases where parameter delimiters cannot be interpreted correctly because of rotten syntax.

Instead of starting with `=quotient((`

, it should look like this instead, as @JohnSUN wrote.

`=QUOTIENT(SUM(J18:P18);4)`