[Solved] Is there a way to do that?

[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

[jrkrideau]

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.

[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.

[mriosv]

If in
A1: =1*100+2*50+3*25
in
A2: =FORMULA(A1)

[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

[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.

[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.