Ask Your Question
0

In Writer, in a table, is it possible to subtract one cell from another cell?

asked 2017-02-17 04:11:35 +0100

alohaboy gravatar image

When I use this formula, =<b7>-<b8>, I get the wrong answer. If B7=100 and B8=40, the answer should be 60, but the result I get is -40. Is this possible, and if so, what's the syntax? Thanks!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-02-17 19:31:53 +0100

JohnHa gravatar image

updated 2017-02-17 19:39:05 +0100

... is it possible to subtract [the value stored in] one cell from [the value stored in] another cell?

Yes.

See the documentation and read the chapter on tables and number recognition; or search Help.

edit flag offensive delete link more
0

answered 2017-02-17 04:18:01 +0100

Mike Kaganski gravatar image

updated 2017-02-17 04:23:43 +0100

Your syntax is correct. But the result shows that your "100" in B7 isn't recognized as number. Does it contain e.g. letter "O" instead of a zero?

Another possibility is if you have an error in formula (highly improbable if you used mouse clicks to select cells when entered formula), e.g. use letter similar to B (in Russia e.g., we have a letter В that looks identically, but is a different Cyrillic letter). But then it would give you **Error in expression** and replace your wrong <B7> with <?> upon formula entry finished.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-17 04:11:35 +0100

Seen: 35 times

Last updated: Feb 17