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