Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revealing the contents of a formula | Excel Worksheet Functions | |||
Run a Hyperlink from another cell | Excel Discussion (Misc queries) | |||
How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Hiding a function value in a cell until function used | Excel Worksheet Functions |