Thread
:
Excel 2019: How to display the sign of numbers in another field in brackets?
View Single Post
09-16-2021, 08:21 AM
Jamal NUMAN
Windows 7 64bit
Office 2010 64bit
Expert
Join Date: Nov 2010
Posts: 519
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, 13 views)
Jamal NUMAN
View Public Profile
Find all posts by Jamal NUMAN