Trouble creating a conditional hyperlink

**JPWRana** · 06-27-2013, 01:45 AM

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?

**vlady** · 06-27-2013, 01:55 AM

try
from (1)

to
"("&SUM(O4,B23)&")")

**JPWRana** · 06-27-2013, 09:20 AM

Thank you vlady! With a little tweaking, it worked. I used

HYPERLINK($B$57&$G$1&"\"&$D$2&"\"&$B27&"("&SUM(O$4,$N27)&")"&".JPG","("&SUM(O$4,$N27)&")", "filename("&")SUM(O$4,$N27)&")")

**JPWRana** · 06-27-2013, 09:51 AM

vlady, I click on the star, but I get the message saying: "This post has not received any reputation. You currently have 10 reputation point(s).

Am I doing something wrong?