if function

[Guest]

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

 

[Ardus Petus]

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

HTH

 

[Guest]

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: