Thread: Excel 2019: How to display the sign of numbers in another field in brackets?
View Single Post
 
Old 09-16-2021, 04:54 AM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)"))
and copy down
Reply With Quote