Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|