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
    138
    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
    Westwood NJ
    Posts
    2,581
    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

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
  •