[Solved] Formula to figure + or -

Discuss the spreadsheet application
Post Reply
DougMPhoto
Posts: 2
Joined: Sat Aug 28, 2021 2:56 am

[Solved] Formula to figure + or -

Post by DougMPhoto »

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
Last edited by robleyd on Sat Aug 28, 2021 5:47 am, edited 1 time in total.
Reason: Tag [Solved]
OpenOffice 4.1.7 on Windows 10
User avatar
robleyd
Moderator
Posts: 5056
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Formula to figure + or -

Post by robleyd »

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
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Formula to figure + or -

Post by RusselB »

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.
Last edited by robleyd on Sat Aug 28, 2021 4:41 am, edited 1 time in total.
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.
DougMPhoto
Posts: 2
Joined: Sat Aug 28, 2021 2:56 am

Re: Formula to figure + or -

Post by DougMPhoto »

Thanks guys, that works. I was working something completely different and my mind went blank.
OpenOffice 4.1.7 on Windows 10
Post Reply