Using IF function for many many cells, and using more than one IF function
 

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