View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default If Function with multiple variables

If both variables need to be true, you can use the And function, as in:

=if(and(a1=1,b1=2),true,false)

If either variable need to be true, you can use the Or function, as in:

=if(or(and=1,b1=2),true,false)

Regards,
Fred

"Fritz" wrote in message
...
On a worksheet, I am using an If function, but now I need to add a second
set
of variables to that If function, how can I accomplish that?