Thread: if function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi
 
Posts: n/a
Default 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