#1   Report Post  
Posted to microsoft.public.excel.misc
Mark
 
Posts: n/a
Default Link 2 cells into 1

I want to know if possible to take the values of two different cells and
display it in a third. Example:
A1 = .98
B1 = 100%
Now I want to display it in C1 as .98/100%. Is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Link 2 cells into 1

=TEXT(A1,".00")&"/"&TEXT(B1,"000%")

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
link multiple cells to multiple cells jpoltor Excel Discussion (Misc queries) 2 March 25th 06 08:59 AM
link multiple cells to multiple cells jpoltor Excel Discussion (Misc queries) 1 March 22nd 06 08:10 AM
Link picture between cells Scofflaw1269 Excel Worksheet Functions 1 November 27th 05 04:12 PM
How to link website data to Excel cells Tony Excel Discussion (Misc queries) 4 September 28th 05 04:16 PM
Can you Link 3 cells into 1 in Excel 2003 lin Excel Worksheet Functions 2 June 8th 05 09:38 AM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"