m2 after a sum equation
m2 after a sum equation
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: m2 after a sum equation

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

    Default

     
    Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-10 04:36, Johnny_Naughts wrote:
    Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible
    Change your formula to:

    =your-formula&" m2"


  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Belgium
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Yes, it is possible, but your cell will become text and therefore can't be summed (e.g.) later with another one without removing the m2)

    If in Cell(1,2) you want to have the result of Cell (1,1) + m2, write the code as follows:
    =C1 & " m2"
    The '&' concatenate one string with another. Your first string is determined by the result of C1 and second is enabled by the ' " ' text operator.
    good luck

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
  •  

 

 
DMCA.com