double cell reference?

Feb 28th, 2002, 02:56 PM

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?

gplhl · Feb 28th, 2002, 03:09 PM

Quote:

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)

Feb 28th, 2002, 04:08 PM

Better still try this:

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

Mar 1st, 2002, 07:00 AM

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!

Chris Davison · Mar 3rd, 2002, 09:49 AM

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

Anne Troy · Mar 3rd, 2002, 10:09 AM

Or just:

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

Chris Davison · Mar 3rd, 2002, 02:00 PM

Dreamboat

that option makes me nervous

Mar 3rd, 2002, 09:49 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ::

Mar 3rd, 2002, 10:09 AM	#6
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Or just: =Critical.Data!D34&"/"&Critical.Data!D36*100&"%" __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 02:56 PM	#1
Guest Posts: n/a	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?

Feb 28th, 2002, 04:08 PM	#3
Guest Posts: n/a	Better still try this: =Critical.Data!D34&"/"&Critical.Data!D36

Mar 1st, 2002, 07:00 AM	#4
Guest Posts: n/a	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!

Mar 3rd, 2002, 02:00 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Dreamboat that option makes me nervous