Thread
:
Excel 2019: How to display the sign of numbers in another field in brackets?
View Single Post
09-16-2021, 04:54 AM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)"))
and copy down
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets