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)

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 02:32 AM.