If Function with multiple variables

F

Fritz

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

Nick Hodge

Fritz

Just nest them. You can go up to 7 levels deep in versions before 2007 (Some
more using range names) but if you need more that that you should really
consider a table and VLOOKUP or similar. the syntax for IF are

=IF(test,
this_value_if_true,IF(test2,this_value_if_true2,this_value_if_false2))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 
F

Fred Smith

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
 
Top