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

A

Aikisteve

HI all, total newbie to this whole excel thing.

Is there a way to use an IF function for several cells with a hyperlin
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 rang
=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 t
make this function to add the word "car" into a different cell than th
one the function is in.

Seems like i have asked a lot. Sorry guy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 3
Needs help combining functions. 3
Need help finding a substring in a array of strings. 1
get a cell reference as a result of an If Function 1
Excel Countif Function - Calculating Between Two Sets of Values 3
VBA - Hyperlink Function Combined with Find 6
SUMIF using value from MOD function 2
Concatenate many cells 8

Top