Multiple If Situation

Adminboy · Apr 18th, 2002, 02:02 PM

I am needing to use a function similiar to IF (which returns one value if a condition is True, and another value if the same condition is False), but have more than 2 conditions (requiring more than just True or False). Is there a function that will help me?

Al Chara · Apr 18th, 2002, 02:09 PM

You can try some nested IF statements or IF with SUMPRODUCT. Maybe you need to use COUNTIF or COUNTA. Really hard to tell without an example or more information.

Mark O'Brien · Apr 18th, 2002, 02:40 PM

An example is definitely in order.

You could need to OR or AND some IF statements.

lenze · Apr 18th, 2002, 02:40 PM

If your test can be represented as a number instead of true or false, you can use the CHOOSE function. This will give you 31 options. If it can't, you might be able to combine VLOOKUP to get the desired result (ie A number from 1 -31)and then use CHOOSE.

Al Chara · Apr 18th, 2002, 03:06 PM

Quote:

On 2002-04-18 09:40, lenze wrote:
If your test can be represented as a number instead of true or false, you can use the CHOOSE function. This will give you 31 options. If it can't, you might be able to combine VLOOKUP to get the desired result (ie A number from 1 -31)and then use CHOOSE.

In XL2000 you only have index numbers 1-29.

Apr 18th, 2002, 02:09 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can try some nested IF statements or IF with SUMPRODUCT. Maybe you need to use COUNTIF or COUNTA. Really hard to tell without an example or more information. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 02:02 PM	#1
Adminboy Join Date: Apr 2002 Posts: 1	I am needing to use a function similiar to IF (which returns one value if a condition is True, and another value if the same condition is False), but have more than 2 conditions (requiring more than just True or False). Is there a function that will help me?

Apr 18th, 2002, 02:40 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,510	An example is definitely in order. You could need to OR or AND some IF statements.

Apr 18th, 2002, 02:40 PM	#4
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 11,730	If your test can be represented as a number instead of true or false, you can use the CHOOSE function. This will give you 31 options. If it can't, you might be able to combine VLOOKUP to get the desired result (ie A number from 1 -31)and then use CHOOSE.