Joining/Linking nested formulas

[Aikisteve]

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

[Ardus Petus]

=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
>