if function
 

is it possaiable to get the if comand to respond with something based on two
cells, if so how is it done

Thanks for any help you can give

if function
 

=IF(and(A1="something";B1="whatever"),"OK","bad")

HTH
--
AP
"Dreamstar_1961" a écrit dans le
message de news: ...
is it possaiable to get the if comand to respond with something based on
two
cells, if so how is it done

Thanks for any help you can give

if function
 

Yes, first you have to determine the conditions for both cells, the the
logical relation of these conditions, say in this example AND, then this
formula

=IF(AND(A1="a",B1="b"),"yes","no")

returns "yes" if cell A1="a" and cell B1="b".

Regards,
Stefi

€žDreamstar_1961€� ezt Ã*rta:

is it possaiable to get the if comand to respond with something based on two
cells, if so how is it done

Thanks for any help you can give