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?
|