if function

D

Dreamstar_1961

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
 
S

Stefi

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:
 
Top