Concatenate - can i find a result from this function (part of it)?

[sajmen]

Hi,

I need to find part of a result from function - concatenate.
Let me explain by screens - would be much easier.

I got some basic equation,
Lets focus on first screen (excel1) on: (hmin=0,04*21,53)
Its goes from (excel2) (sorry for default language if need english i can change)
On third step (excel3) i show on red what i want drawn from this equation
I want extract parts, where are calculations...
I dont want to repeat everytime same formula like (in this example): ROUND(1,05*C7;2)
I want this 21,53 [ROUND(1,05*C7;2)] without typing that...

Is there any chance to drawn it?
Is there any function like =find calcutation from this cell??

I know its a bit confusing but i tried to explain best way i could.

Thanks for replay guys,

[karedog]

Hi,

First, select a cell where you want to put the repetitive value, for example let's choose D7.

Put this formula on D7 :

Please Login or Register  to view this content.

Formula for hmin :

Please Login or Register  to view this content.

Formula for hmax :

Please Login or Register  to view this content.

[sajmen]

Thanks for replay,

But i don't want to move my formula out of my paper, my idea is that i would like to have everything on like's going on without any "links"...
Don't want to have any "helpfull" cell's - just do everything on "concatenate"...

I want this because this "=ROUND(1.05*C7;2)" as u said can change innner formula like =ROUND(1.15*C7;2)"

I would like to have in concatenate just some formula like =read'me'in'this'cell'only'calculation'without other things'

Is it even possible?

Thanks

[karedog]

Actually, I don't catch what you mean clearly, but I guess this is what you mean :

Assume that hmin is at F7 with formula :

Please Login or Register  to view this content.

Formula for hmax, based on part of F7 is :

Please Login or Register  to view this content.

You should change above formula to match your regional settings (dot to comma, comma to semicolon).

[sajmen]

That's it) that what i was looking for))
I was close - I used function MID but i couldnt exploit the potential
Thanks again

[karedog]

You're welcom sajmen, and thanks for the reputation points