Multiple If Situation

Adminboy

New Member
Joined
Apr 17, 2002
Messages
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?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top