View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge[_2_] Nick Hodge[_2_] is offline
external usenet poster
 
Posts: 185
Default If Function with multiple variables

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?