I have a value in A1.
I want to type in values in A2 through A30. Each value I type in, I want it to subtract from the value in A1. The total where it is calculated would be in A31.
Anyone that can help me figure out what the formula is?
[Solved] How to subtract from 1 cell only
-
usmdesigner
- Posts: 5
- Joined: Fri Jan 21, 2022 6:36 pm
[Solved] How to subtract from 1 cell only
Last edited by usmdesigner on Wed Feb 16, 2022 6:51 pm, edited 1 time in total.
OpenOffice 6.3.3.2 on Windows 10
Re: How to subtract from 1 cell only
One solution if I understand your question correctly; in A31 put
Code: Select all
=A1-SUM(A2:A30)Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.5.2; SlackBuild for 26.2.5 by Eric Hameleers
-----------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Apache OpenOffice 4.1.16
LibreOffice 26.2.5.2; SlackBuild for 26.2.5 by Eric Hameleers
-----------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Re: How to subtract from 1 cell only
usmdesigner,
please upload your ODF type sample file here.
please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
usmdesigner
- Posts: 5
- Joined: Fri Jan 21, 2022 6:36 pm
Re: How to subtract from 1 cell only
Thanks! This worked perfectly!robleyd wrote:One solution if I understand your question correctly; in A31 putCode: Select all
=A1-SUM(A2:A30)
OpenOffice 6.3.3.2 on Windows 10