Ask Your Question
0

Subtraction Function

asked 2018-01-31 01:39:38 +0200

jolive gravatar image

What is a simple subtraction formula from one cell to the next?

edit retag flag offensive close merge delete

Comments

You mean =A1-A2?

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-31 06:46:36 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-01-31 17:27:23 +0200

Jim K gravatar image

updated 2018-01-31 17:29:31 +0200

A spreadsheet function is not needed, only the operator -. For example, enter 5 in A1 and =A1-3 in B1.

result in B1

Similarly, +, * or / can be used for addition, multiplication or division respectively.

edit flag offensive delete link more
0

answered 2018-01-31 17:54:59 +0200

librebel gravatar image

Apart from the minus operator, you could also use the built-in Calc function RAWSUBTRACT()

Calc function RAWSUBTRACT

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-31 01:39:38 +0200

Seen: 5,846 times

Last updated: Jan 31 '18