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