Excel double cell reference? :: MrExcel Message Board



 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

double cell reference?
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

Guest




Posts: 18




 Reply with quote  

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?

Post Thu Feb 28, 2002 6:56 pm 
 

gplhl
Board Master


Joined: 24 Feb 2002
Posts: 118
Location: Chippenham, UK

Status: Offline

 Reply with quote  


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)


_________________
Regards,

Gary Hewitt-Long

Post Thu Feb 28, 2002 7:09 pm 
 View user's profile Send private message Send e-mail

Guest




Posts: 18




 Reply with quote  

Better still try this:

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

icon_rolleyes.gif

Post Thu Feb 28, 2002 8:08 pm 
 

Guest




Posts: 18




 Reply with quote  

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!

Post Fri Mar 01, 2002 11:00 am 
 

Chris Davison
MrExcel MVP


Joined: 16 Feb 2002
Posts: 1715
Location: Millbank, London, UK

Status: Offline

 Reply with quote  

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




_________________
Hope this helps,
Chris
icon_smile.gif
[Excel '97; Windows ME]

Post Sun Mar 03, 2002 1:49 pm 
 View user's profile Send private message Send e-mail ICQ Number

Dreamboat
anne@MrExcel


Joined: 19 Feb 2002
Posts: 1045
Location: Southeastern Pennsylvania
Flag: Usa

Status: Offline

 Reply with quote  

Or just:

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

Post Sun Mar 03, 2002 2:09 pm 
 View user's profile Send private message Send e-mail

Chris Davison
MrExcel MVP


Joined: 16 Feb 2002
Posts: 1715
Location: Millbank, London, UK

Status: Offline

 Reply with quote  

Dreamboat

icon_smile.gif

that option makes me nervous

Post Sun Mar 03, 2002 6:00 pm 
 View user's profile Send private message Send e-mail ICQ Number
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.