double cell reference?

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

Thread: double cell reference?

  1. #1
    Guest

    Default

     
    Quick question: I have two cells (D34, D36)in a sheet named "Critical.Data" that I would like to reference into a single cell (A3) on a separate worksheet named "Summary". In other words, I would like "A3" in the "Summary" sheet to list the values contained in both "D34" and "D36" from "Critical Data". Also, I would like the two values to be separated by a slash ("/")...any ideas?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-28 13:56, Anonymous wrote:
    Quick question: I have two cells (D34, D36)in a sheet named "Critical.Data" that I would like to reference into a single cell (A3) on a separate worksheet named "Summary". In other words, I would like "A3" in the "Summary" sheet to list the values contained in both "D34" and "D36" from "Critical Data". Also, I would like the two values to be separated by a slash ("/")...any ideas?
    Try putting this in A3
    =CONCATENATE(Critical.Data!D34,"/",Critical.Data!D36)

    Regards,

    Gary Hewitt-Long

  3. #3
    Guest

    Default

    Better still try this:

    =Critical.Data!D34&"/"&Critical.Data!D36


  4. #4
    Guest

    Default

    Thanks for the tip...now I have a question...I am using this formula now in a variety of instances, and have come across the following problem-

    In one instance, I am bringing the values from two separate cells into the same cell as explained- one is a plain number, and the other is a %. The thing is, when i bring them together, the % loses its format (ie- it doesn't read 4.01%, it now reads .0041) I can't simply format the cell, b/c it will change the other figure into a %, which I do not want. Is there any way I can only format the second value I am bringing into the cell?

    Also, another problem I am running into has to do with a web query- I am pulling another piece of info from another sheet in similar fashion, but the problem is that this number changes from a date to a plain number throughout the day. Thus, the cell to which I am referencing it needs to be formatted in a way in which it recognizes this and formats accordingly (formats date when a the cell shows a date, and formats a plain number when it shows a regular number) Don't know if this is confusing or if anyone can help...Thanks!

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    dunno about the web thing, but the %age formatting could go something like this :

    =Critical.Data!D34&"/"&TEXT(Critical.Data!D36,"#,###.00%")

    adjust the decimals to suit your needs



    :: Pharma Z - Family drugstore ::

  6. #6
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Arlington Heights, IL
    Posts
    2,572
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or just:

    =Critical.Data!D34&"/"&Critical.Data!D36*100&"%"
    ~Anne Troy

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Dreamboat



    that option makes me nervous

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