Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sans
 
Posts: n/a
Default HYPERLINK IF referencing the cell of the function..

I want to set all the cells in a column to have the same funtion, so every
numerical value I enter into that cell will be translated into a hyperlink
that uses that same number.. This is what I have so far..

=IF(ISNUMBER(TRUE),HYPERLINK(CONCATENATE("http://www.website.com/script?id=",VALUE OF THIS CELL,"&header=Y&status=I&view=D"),VALUE OF THIS CELL),FALSE)

In other words.. every cell in this column is blank. The function is simply
waiting for a number.

I swear I saw in the help documentation a way to reference the containing
cell's value. Usually that would cause a loop back, but in this situation is
won't.
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
revealing the contents of a formula srinivasan Excel Worksheet Functions 10 July 5th 05 04:39 PM
Run a Hyperlink from another cell AO Excel Discussion (Misc queries) 0 June 17th 05 11:26 AM
How do I obtain the address of a cell using the vlookup function? Spock Excel Worksheet Functions 2 May 16th 05 06:35 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Hiding a function value in a cell until function used Paul Smithson Excel Worksheet Functions 1 February 25th 05 06:19 PM


All times are GMT +1. The time now is 04:06 PM.

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

About Us

"It's about Microsoft Excel"