Remember Me?

#1
January 28th 08, 10:36 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 29
If Function with multiple variables

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?

#2
January 28th 08, 10:42 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2007 Posts: 186
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?

#3
January 28th 08, 11:33 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2008 Posts: 2,389
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post DaS Excel Worksheet Functions 10 August 24th 07 11:55 PM Ang Excel Worksheet Functions 3 April 27th 07 08:24 PM Bob Excel Worksheet Functions 13 November 23rd 05 12:56 AM Bob Excel Worksheet Functions 0 November 22nd 05 02:12 AM cin Excel Worksheet Functions 2 September 8th 05 09:32 PM

All times are GMT +1. The time now is 01:20 AM.