Page 1 of 1
[Solved] Is there a way to do that?
Posted: Thu Aug 04, 2011 6:46 pm
by xamlet
Hi guys,
i'm not exactly the newbie with OO but today i got a problem to find a solution.
so I have a cells with simple math operations like a*b+c*d+e*f i need them shown on table and in the next cell i need to have sum from that. I tryed alot of things but with no success i would be very happy if someone can show me a decision of my problem. Maybe its a really stupid question but i didn't find any way to make it run.
Thanks in advice
Re: Is there a way to do that?
Posted: Thu Aug 04, 2011 7:14 pm
by jrkrideau
xamlet wrote:Hi guys,
i'm not exactly the newbie with OO but today i got a problem to find a solution.
so I have a cells with simple math operations like a*b+c*d+e*f i need them shown on table and in the next cell i need to have sum from that. I tryed alot of things but with no success i would be very happy if someone can show me a decision of my problem. Maybe its a really stupid question but i didn't find any way to make it run.
Thanks in advice
Can you give us an example? I am not clear on what you want summed.
Re: Is there a way to do that?
Posted: Thu Aug 04, 2011 7:16 pm
by xamlet
i need to have in one cell 1*100+2*40+3*25 that should be printable as it is, and in other cell i need to have the end result from that currently 255.
Re: Is there a way to do that?
Posted: Thu Aug 04, 2011 7:22 pm
by mriosv
If in
A1: =1*100+2*50+3*25
in
A2: =FORMULA(A1)
Re: Is there a way to do that?
Posted: Thu Aug 04, 2011 7:40 pm
by xamlet
it is not the exactly what i needed but its a step in right direction
for me it would be the best thing to have A1 with 1*100+2*50+3*25 without "=" and than to have it calculated in A2
but anyway hope that will helps me alot
Thanks
Re: Is there a way to do that?
Posted: Thu Aug 04, 2011 8:36 pm
by Hagar Delest
Code: Select all
=RIGHT(FORMULA(A2);LEN(FORMULA(A2))-1)
Please add '[Solved]' at the beginning of your
first post title (
edit button) if your issue has been fixed.
Re: Is there a way to do that?
Posted: Thu Aug 04, 2011 8:59 pm
by JohnSUN-Pensioner
I think I understood! You will need an analog of function EVAL()?
Try to read
this discussion. It is the Russian language. But the Google-translator to help you. There are interesting not so much a debate as applied solutions.