Joining/Linking nested formulas
 

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

Joining/Linking nested formulas
 

=HYPERLINK("C:\Documents and Settings\Mullinss\Desktop\"&A1,A1)

No error checking!

HTH
--
AP

"Aikisteve" a écrit
dans le message de news:
...

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