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