Results 1 to 5 of 5

Trouble creating a conditional hyperlink

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    253

    Question Trouble creating a conditional hyperlink

    The following hyperlink formula in itself works:
    =HYPERLINK($B$57&$G$1&"\"&$D$2&"\"&$B27&"(1).JPG","(1)"),"")

    B57 is a url path
    D2 is a folder path
    N27 is the file name

    Therefore my hyperlink will open up a web file with the friendly name "filename(1)"

    What I would like to do is have the (1) part of the hyperlink formula be changed to be SUM(1+4) OR (SUM O4, B23)

    O4 = 1 (this number is static)
    B23=4 (this number is dynamic. It could be a 1, 2, 3, or 4)

    So that the NEW file path will slightly be modified in that instead of opening up "URL...\filename(1)" it will open up "URL...\filename(5)" because 1(O24) + 4(N27) = 5,

    and so the friendly name of the hyperlink will be "filename(5)".

    Is this possible?
    Last edited by JPWRana; 06-27-2013 at 09:13 AM. Reason: B23 Should be N27 instead

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1