I have 4 columns:
Item------------- Last -------------- Current --------- Difference
item 1------- $35000.00 ------- $36,000.00 ------- $1000.00
Item 2------- $36000.00 ------- $34,000.00 ------- (-$2000.00)
How would I write a formula (if possible) to automatically show if the difference is a Positive or Negative number. Right now I have:
Item 1 "Difference" formula as ( Current - Last ) to give a positive number.
Item 2 "Difference" formula as ( Last - Current ) to give a negative number.
If the "Current" number changes is there a way for it to automatically change it to a positive or negative. Like if I would change Item 2 "Current" to $36,500.00 it would make the "Difference" + $500.00 instead of (-$500) (negative).
Right now I am changing the "Difference" formulas each time I change the amount to make it positive or negative.
I hope you can understand what I mean.
Thanks in advance.
Doug
[Solved] Formula to figure + or -
-
- Posts: 2
- Joined: Sat Aug 28, 2021 2:56 am
[Solved] Formula to figure + or -
Last edited by robleyd on Sat Aug 28, 2021 5:47 am, edited 1 time in total.
Reason: Tag [Solved]
Reason: Tag [Solved]
OpenOffice 4.1.7 on Windows 10
Re: Formula to figure + or -
In both cases, Current - Last should return the result you want.
Code: Select all
Item Last Current Difference
item 1 $35000.00 $36,000.00 $1000.00
Current-Last = 1000
Item 2 $36000.00 $34,000.00 (-$2000.00)
Current-Last = -2000
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: Formula to figure + or -
If you find that David's suggestion doesn't work, please upload a sample spreadsheet showing the information that proves it doesn't work.
See How to attach a document for assistance in anonymizing and attaching a document for us to examine.
See How to attach a document for assistance in anonymizing and attaching a document for us to examine.
Last edited by robleyd on Sat Aug 28, 2021 4:41 am, edited 1 time in total.
Reason: Fix broken link
Reason: Fix broken link
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
-
- Posts: 2
- Joined: Sat Aug 28, 2021 2:56 am
Re: Formula to figure + or -
Thanks guys, that works. I was working something completely different and my mind went blank.
OpenOffice 4.1.7 on Windows 10