Link to home
Start Free TrialLog in
Avatar of allenkent
allenkentFlag for United States of America

asked on

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
Avatar of jimyX
jimyX

in B1:
=IF(ISERROR(FIND("-",A1)),"+","-")
in C1:
=ABS(A1)

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

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

Sincerely,
Ed
ASKER CERTIFIED SOLUTION
Avatar of jimyX
jimyX

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of allenkent

ASKER

Solution provided me with desired results. Thx.