Ask Your Question

Calc: Why is a <~> impossible to delete?

asked 2018-05-11 17:59:17 +0200

abi gravatar image

updated 2018-05-12 22:08:43 +0200

LibreTraining gravatar image

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 ...

edit retag flag offensive close merge delete


What about the closing bracket after P18? I mean =QUOTIENT(SUM(J18:P18);4)

JohnSUN gravatar imageJohnSUN ( 2018-05-11 18:50:45 +0200 )edit

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:
Invalid argument Function argument is not valid.
For example, ...

Lupp gravatar imageLupp ( 2018-05-12 22:22:27 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-12 09:36:52 +0200

Jim K gravatar image

updated 2018-05-12 09:37:33 +0200

Quoting @Lupp from

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-11 17:59:17 +0200

Seen: 66 times

Last updated: May 12 '18