Formula help
 

I am using a way to do the following

column1 column 2 column 3
(2+3)+(3*5) 5+15 20


in the first column I want to be able to see the expresion
in the second column I want to have the result of each parenthesis
and in the final column the result

Please help
Thanks
Stelios

Formula help
 

In B1 enter:
=MID(A1,2,1)+MID(A1,4,1) & "+" & MID(A1,8,1) *MID(A1,10,1)

In C1 enter:
=RIGHT(B1,2)+LEFT(B1,1)

--
Gary''s Student - gsnu2007d


"Stelios" wrote:

I am using a way to do the following

column1 column 2 column 3
(2+3)+(3*5) 5+15 20


in the first column I want to be able to see the expresion
in the second column I want to have the result of each parenthesis
and in the final column the result

Please help
Thanks
Stelios

Formula help
 

ok
this is a start but in the first column I have different number of relations

for example
Column1
(2*5*7)+(0.5*14*75/2)-(54+65+74)

I have to write down another formula.

the problem beggins here
I have to do a series of additions or subtractions and
then print them on a piece of paper.
Then the person that will take that paper and check the operations to have
the result of each parenthesis.

Thanks alot
Stelios

"Gary''s Student" wrote in message
...
In B1 enter:
=MID(A1,2,1)+MID(A1,4,1) & "+" & MID(A1,8,1) *MID(A1,10,1)

In C1 enter:
=RIGHT(B1,2)+LEFT(B1,1)

--
Gary''s Student - gsnu2007d


"Stelios" wrote:

I am using a way to do the following

column1 column 2 column 3
(2+3)+(3*5) 5+15 20


in the first column I want to be able to see the expresion
in the second column I want to have the result of each parenthesis
and in the final column the result

Please help
Thanks
Stelios

Formula help
 

In the most general case you would need a parser. This is a program to take
Excel's formulaic syntax and successively decompose expressions. See:

http://www.cs.uwindsor.ca/~hafiz/proHome.html
--
Gary''s Student - gsnu200770


"Stelios" wrote:

ok
this is a start but in the first column I have different number of relations

for example
Column1
(2*5*7)+(0.5*14*75/2)-(54+65+74)

I have to write down another formula.

the problem beggins here
I have to do a series of additions or subtractions and
then print them on a piece of paper.
Then the person that will take that paper and check the operations to have
the result of each parenthesis.

Thanks alot
Stelios

"Gary''s Student" wrote in message
...
In B1 enter:
=MID(A1,2,1)+MID(A1,4,1) & "+" & MID(A1,8,1) *MID(A1,10,1)

In C1 enter:
=RIGHT(B1,2)+LEFT(B1,1)

--
Gary''s Student - gsnu2007d


"Stelios" wrote:

I am using a way to do the following

column1 column 2 column 3
(2+3)+(3*5) 5+15 20


in the first column I want to be able to see the expresion
in the second column I want to have the result of each parenthesis
and in the final column the result

Please help
Thanks
Stelios