#VALUE! in OpenOffice Calc
Solved
ptrv97
Posted messages
4
Registration date
Status
Membre
Last intervention
-
ptrv97 Posted messages 4 Registration date Status Membre Last intervention -
ptrv97 Posted messages 4 Registration date Status Membre Last intervention -
Hello everyone!
For the new school year, I have a physics assignment to submit, which requires good spreadsheet skills. However, as you can see, I'm starting off poorly since I can't solve a problem that prevents me from starting this darn activity... It turns out that when I try to enter the distance over time ratio, well, the result is hard to come by... "#VALUE!" is what I'm being told! I've made countless attempts, to no avail. Anyway, if a kind soul understands what's wrong, I would be grateful, because I won't hide it from you, this situation is driving me crazy!
Here are some pictures:
Thank you in advance!
For the new school year, I have a physics assignment to submit, which requires good spreadsheet skills. However, as you can see, I'm starting off poorly since I can't solve a problem that prevents me from starting this darn activity... It turns out that when I try to enter the distance over time ratio, well, the result is hard to come by... "#VALUE!" is what I'm being told! I've made countless attempts, to no avail. Anyway, if a kind soul understands what's wrong, I would be grateful, because I won't hide it from you, this situation is driving me crazy!
Here are some pictures:
Thank you in advance!
2 réponses
Hello,
With a right-click "Open link in a new tab," the images become readable.
However, a file sent using Cjoint.com would be very useful.
The values are aligned to the left in column B; we can therefore assume that these are text values and not numbers.
To check, enter the formula =ISNUMBER(B4) in D4.
With a right-click "Open link in a new tab," the images become readable.
However, a file sent using Cjoint.com would be very useful.
The values are aligned to the left in column B; we can therefore assume that these are text values and not numbers.
To check, enter the formula =ISNUMBER(B4) in D4.
ptrv97
Posted messages
4
Registration date
Status
Membre
Last intervention
Indeed, the clipboard had included an apostrophe before the values, so I suppose OpenOffice considered it as a text data rather than a numeric one! I removed the apostrophe and it worked, thank you very much!
