|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
|||
|
|||
Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)")) |
#3
|
|||
|
|||
Quote:
Thank you for the answer. What if i need to write the (-) and (+) in the same column as in the screenshot below?
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
|||
|
|||
You could easily use a custom format for this.
Custom Format
|
|
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 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 |
How to add the plus sign (+) automatically for the numbers which are positive? | Jamal NUMAN | Excel | 2 | 05-01-2011 03:15 PM |