View Single Post
 
Old 09-16-2021, 08:21 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
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
File Type: jpg Clip_891.jpg (47.1 KB, 13 views)
Reply With Quote