Show a plus or minus result

Discuss the spreadsheet application
Post Reply
jeffrey3600
Posts: 19
Joined: Sat Jan 21, 2017 7:56 pm

Show a plus or minus result

Post by jeffrey3600 »

The result of two cells could be a plus or a minus. What formula sign would I use to calculate. For example cell 1 is 25 cell 2 is 10. or cell 1 is 10 and cell 2 is 25.

Thanks.
open office 4.1.3 on Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: show a plus or minus result

Post by RoryOF »

Right click on the cell that is to contain the calculation, choose Format Cells from the popup, then the Numbers tab. In Category box choose Number and your desired format in the Format box. Start with General. If you wish negative numbers red, check that box as well.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
jeffrey3600
Posts: 19
Joined: Sat Jan 21, 2017 7:56 pm

Re: show a plus or minus result

Post by jeffrey3600 »

Thanks. My question is really about the RESULTS of a formula. If the result is negative it should show a - , if positive no sign. I know that there is a simple answer out there. Your post was helpful for other reasons.
open office 4.1.3 on Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: show a plus or minus result

Post by RoryOF »

The Results of a formula show in the cell in which that formula is placed, so the formatting I describe will apply to that result, as normally a formula is not displayed.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Show a plus or minus result

Post by Hagar Delest »

See if that old topic helps: [Solved] Plus Signs in Numbers.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply