HI all, total newbie to this whole excel thing.
Is there a way to use an IF function for several cells with a hyperlink
function tied in e.g
=IF(A1=100,Hyperlink("www.exceltip.com","false"))
that seems to work, but i want it to apply if any cell in the A range
=100, how do i do it?
ALSO
is it possible to link another If function to the A range e.g
=IF(A1=200,HYPERLINK("www.excelforum.com","false") )
Can this be made to add things into a cell, if for example i wanted to
make this function to add the word "car" into a different cell than the
one the function is in.
Seems like i have asked a lot. Sorry guys
--
Aikisteve
------------------------------------------------------------------------
Aikisteve's Profile:
http://www.excelforum.com/member.php...o&userid=36111
View this thread:
http://www.excelforum.com/showthread...hreadid=558847