How do you link nested formulas. I have
=IF(A1="Red",HYPERLINK("C:\Documents and Settings\Mullinss\Desktop\Red","Red"))
This works fine, but i want the same to apply, in the same cell, if the word in A1 is Yellow, Blue Green Etc
How do you link nested formulas. I have
=IF(A1="Red",HYPERLINK("C:\Documents and Settings\Mullinss\Desktop\Red","Red"))
This works fine, but i want the same to apply, in the same cell, if the word in A1 is Yellow, Blue Green Etc
=HYPERLINK("C:\Documents and Settings\Mullinss\Desktop\"&A1,A1)
No error checking!
HTH
--
AP
"Aikisteve" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> How do you link nested formulas. I have
>
> =IF(A1="Red",HYPERLINK("C:\Documents and
> Settings\Mullinss\Desktop\Red","Red"))
>
> This works fine, but i want the same to apply, in the same cell, if the
> word in A1 is Yellow, Blue Green Etc
>
>
> --
> Aikisteve
> ------------------------------------------------------------------------
> Aikisteve's Profile:
> http://www.excelforum.com/member.php...o&userid=36111
> View this thread: http://www.excelforum.com/showthread...hreadid=559389
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks