Thread
:
Joining/Linking nested formulas
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
external usenet poster
Posts: 718
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
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus