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

[Aikisteve]

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

[smb_146]

Here is the formula for first question
=IF(A1=100,HYPERLINK("www.exceltip.com","ExcelTip.com"),IF(A2=200,HYPERLINK("www.excelforum.com","Excel Forum"),IF(A2=300,HYPERLINK("www.example3.com"),IF(A2=400,HYPERLINK("www.example4.com),"FALSE")))))

for details search these terms on google or youtube "nested if function"

for 2nd PART of your question IF function can't do this. I mean if function can only modify the value of the Cell in which the formula is written. But this can be done through VBA.