We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

johnnyquest's profile - activity

2021-05-03 15:03:38 +0200 received badge  Famous Question (source)
2021-05-03 10:50:39 +0200 commented question Using VALUE function to compare two numbers yields incorrect results

Changing the formula to use ROUND instead of VALUE cures the "match" column issue (column C in the example file). This w

2021-05-02 23:47:53 +0200 commented question Using VALUE function to compare two numbers yields incorrect results

File attached. Thank you. JQ

2021-05-02 23:47:33 +0200 edited question Using VALUE function to compare two numbers yields incorrect results

Using VALUE function to compare two numbers yields incorrect results Hello: Currently, I am running Libreoffice CALC Ver

2021-05-02 06:34:08 +0200 commented question Using VALUE function to compare two numbers yields incorrect results

I have an example file prepared with notes but how do I attach a file? There seems to be no way to do so. :(

2021-05-02 01:24:50 +0200 received badge  Notable Question (source)
2021-05-01 20:45:38 +0200 edited question Using VALUE function to compare two numbers yields incorrect results

Using VALUE function to compare two numbers yields incorrect results Hello: Currently, I am running Libreoffice CALC Ver

2021-05-01 20:45:38 +0200 received badge  Editor (source)
2021-05-01 20:45:10 +0200 commented question Using VALUE function to compare two numbers yields incorrect results

Interesting. I spent some time going though all 1800+ rows. When I entered an actual number instead of a formula for col

2021-05-01 11:45:48 +0200 received badge  Popular Question (source)
2021-05-01 00:25:27 +0200 asked a question Using VALUE function to compare two numbers yields incorrect results

Using VALUE function to compare two numbers yields incorrect results Hello: Currently, I am running Version: 5.1.6.2 - B