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,th is_value_if_false2))
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web:
www.nickhodge.co.uk
"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?