allenkent
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
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
In B1 =IF(LEFT(A1,1)="-","-","+" )
and
in C1 =IF(LEFT(A1,1)="-",RIGHT(A 1,LEN(A1)- 1),A1)
Sincerely,
Ed
and
in C1 =IF(LEFT(A1,1)="-",RIGHT(A
Sincerely,
Ed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solution provided me with desired results. Thx.
=IF(ISERROR(FIND("-",A1)),
in C1:
=ABS(A1)
And copy down.
Seperate-Neg-or-Pos-from-Value-u.xls