Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: how do I get whatever number is in a certain cell to another

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to put whatever number that is in say cell Q6 in another cell along with a writin statement. For instance, in cell T6 I want writin: 11.2 * 27.50 * (whatever the number is in cell Q6)
    I do not want this "formula" to work, I just want it to show up in cell T6.

    So it might look like this, if cell Q6 had the number 4 in it:
    11.2 * 27.50 * 4 =
    Thank You,

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use concatenate:

    =CONCATENATE("11.2 * 27.50 * 4 = ",Q6)

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,571
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-06 02:53, CAPT.PT wrote:
    I want to put whatever number that is in say cell Q6 in another cell along with a writin statement. For instance, in cell T6 I want writin: 11.2 * 27.50 * (whatever the number is in cell Q6)
    I do not want this "formula" to work, I just want it to show up in cell T6.

    So it might look like this, if cell Q6 had the number 4 in it:
    11.2 * 27.50 * 4 =
    Thank You,
    =11.2&" * "&27.50&" * "&Q6&" ="



    [ This Message was edited by: Aladin Akyurek on 2002-03-06 03:03 ]

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you Aladin, your suggestion worked out perfect......God Bless! Stay Safe & have a great day!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •