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

		Microsoft Office Forums > Microsoft Excel > Excel
Excel 2019: How to display the sign of numbers in another field in brackets?

09-16-2021, 08:21 AM

Jamal NUMAN Jamal NUMAN is offline

Windows 7 64bit Excel 2019: How to display the sign of numbers in another field in brackets?

Office 2010 64bit

Expert

Join Date: Nov 2010

Posts: 615

Quote:

Originally Posted by ArviLaanemets

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

Clip_891.jpg (47.1 KB, 15 views)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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	0	07-25-2019 11:49 AM
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:26 AM.