[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Excel Formula- Formula that populates other fields,

Hi-
I need an Excel formula that will separate the (-)negative symbol from a negative value in one cell e.g. -3, and put the symbol in a chosen cell and the number 3 in another. Also, If the number is positive have it do the same by putting a positive symbol in one cell and the number in another.

e.g.
A1= -3   Desired Result= B1= -,   C1=3
e.g.
A1= 7    Desired Result=B1= +,   C1=7

Any help greatly appreciated.

Thank you
Seperate-Neg-or-Pos-from-Value.xls
0
allenkent
Asked:
allenkent
  • 2
1 Solution
 
jimyXCommented:
in B1:
=IF(ISERROR(FIND("-",A1)),"+","-")
in C1:
=ABS(A1)

And copy down.
Seperate-Neg-or-Pos-from-Value-u.xls
0
 
MINDSUPERBCommented:
In B1  =IF(LEFT(A1,1)="-","-","+")
and

in C1 =IF(LEFT(A1,1)="-",RIGHT(A1,LEN(A1)-1),A1)

Sincerely,
Ed
0
 
jimyXCommented:
Another way (I think it's the best):

in B1:
=IF(A1>=0,"+","-")

C1 the same:
=ABS(A1)
Seperate-Neg-or-Pos-from-Value-u.xls
0
 
allenkentAuthor Commented:
Solution provided me with desired results. Thx.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now