Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2021, 04:31 AM
Jamal NUMAN Jamal NUMAN is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 7 64bit Excel 2019: How to display the sign of numbers in another field in brackets? Office 2010 64bit
Expert
Excel 2019: How to display the sign of numbers in another field in brackets?
 
Join Date: Nov 2010
Posts: 496
Jamal NUMAN is on a distinguished road
Question Excel 2019: How to display the sign of numbers in another field in brackets?


Excel 2019: How to display the sign of numbers in another field in brackets?

I couldn’t figure out how to display the sign of numbers in another field in brackets as shown in the screenshot below
Attached Images
File Type: jpg Clip_35.jpg (63.3 KB, 10 views)
Reply With Quote
  #2  
Old 09-16-2021, 04:54 AM
ArviLaanemets ArviLaanemets is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 8 Excel 2019: How to display the sign of numbers in another field in brackets? Office 2016
Expert
 
Join Date: May 2017
Posts: 640
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)"))
and copy down
Reply With Quote
  #3  
Old 09-16-2021, 08:21 AM
Jamal NUMAN Jamal NUMAN is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 7 64bit Excel 2019: How to display the sign of numbers in another field in brackets? Office 2010 64bit
Expert
Excel 2019: How to display the sign of numbers in another field in brackets?
 
Join Date: Nov 2010
Posts: 496
Jamal NUMAN is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)"))
and copy down

Thank you for the answer.


What if i need to write the (-) and (+) in the same column as in the screenshot below?
Attached Images
File Type: jpg Clip_891.jpg (47.1 KB, 9 views)
Reply With Quote
  #4  
Old 09-16-2021, 09:44 AM
jeffreybrown jeffreybrown is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 10 Excel 2019: How to display the sign of numbers in another field in brackets? Office 2016
Expert
 
Join Date: Apr 2016
Posts: 647
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

You could easily use a custom format for this.

Custom Format
  • Right click cell (or Ctrl + 1)
  • Format Cells
  • Number
  • Custom
  • Type: "(+)"0;"(-)"0;
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2019 - Black Display when mouse hoovers over the main display CleoLane Outlook 2 09-06-2021 10:07 PM
Excel 2019: How to display the sign of numbers in another field in brackets? Excel 2019: How to display the file path on the title bar? Jamal NUMAN Excel 1 05-05-2020 04:23 AM
Merging phone numbers with + sign WibbleWobble Mail Merge 2 12-28-2019 04:29 AM
What's new in Word 2019, Excel 2019 and Outlook 2019 and Why upgrade to Office 2019 is recommended? einfomail Office 1 07-26-2019 09:44 AM
Excel 2019: How to display the sign of numbers in another field in brackets? How to add the plus sign (+) automatically for the numbers which are positive? Jamal NUMAN Excel 2 05-01-2011 03:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft