Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bart
 
Posts: n/a
Default 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



  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

="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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM
excel CSV is interpreted as HTML MikeDb Excel Discussion (Misc queries) 6 December 10th 04 10:35 AM


All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"