text and values combined in one cel
 

Hello,

Is it possible to combine a cel with text values from a cel?
I have to do something like this:

"Calculated total installed multiplied by duty factor 0,7 or "stated by
supplier x 0,7)"

In this text the "0,7" has to be a value from a certain cel.

Thanks in advance

="The result is "&G1&" according to my cell"

HTH. Best wishes Harald

"Bart" skrev i melding
...
Hello,

Is it possible to combine a cel with text values from a cel?
I have to do something like this:

"Calculated total installed multiplied by duty factor 0,7 or "stated by
supplier x 0,7)"

In this text the "0,7" has to be a value from a certain cel.

Thanks in advance