If function, many ifs but one or two outcome?

**axangec** · 01-08-2016, 05:07 AM

Hi, been searching high and low but didn't find what I need...hopefully some experts here can help me out.

Is it possible for Excel If to perform as such;

A1 cell to display 'INCOME' when B1 shows either any of these (Salary, Cash Deposit, Cashback, Dividend, Interests)
A1 cell to display 'EXPENSE' when B1 shows either any of these (Insurance, Dining Out, Groceries, Household)

Thanks in advance and happy new year!!

**joeu2004** · 01-08-2016, 05:15 AM

Originally Posted by axangec

Is it possible for Excel If to perform as such;
A1 cell to display 'INCOME' when B1 shows either any of these (Salary, Cash Deposit, Cashback, Dividend, Interests)
A1 cell to display 'EXPENSE' when B1 shows either any of these (Insurance, Dining Out, Groceries, Household)

Does this do what you want (entered into A1):

Please Login or Register  to view this content.

But if those are all of the only possible values for B1, perhaps you can simplify it, to wit:

=IF(OR(B1={"Salary","Cash Deposit","Cashback","Dividend","Interests"}),"INCOME","EXPENSE")

**axangec** · 01-08-2016, 05:22 AM

Thanks for the quick response! I didn't know it can be use this way.

However, only INCOME will appear for either (Salary, Cash Deposit, Cashback, Dividend, Interests) but it shows nothing when I key in any of (Insurance, Dining Out, Groceries, Household) in B1 cell...

=IF(OR(B1={"Salary","Cash Deposit","Cashback","Dividend","Interests"}),"INCOME",
IF(OR(B1={"Insurance","Dining Out","Groceries","Household","EXPENSE"}), ""))

**Richard Buttrey** · 01-08-2016, 05:30 AM

It works OK for me as indeed does Joeu's shorter version.

If you claim it's not working for you then can I suggest you upload the workbook you're using in which you've entered the formula.

Are you sure you're not entering any leading or trailing spaces?

**Pepe Le Mokko** · 01-08-2016, 07:22 AM

Seems you have a typo =IF(OR(B1={"Salary","Cash Deposit","Cashback","Dividend","Interests"}),"INCOME",
IF(OR(B1={"Insurance","Dining Out","Groceries","Household"}),"EXPENSE"),"")

**axangec** · 01-10-2016, 03:00 PM

Thanks and sorry for the late reply.

I have input the formula and gotten a 'You've entered too many arguments for this function.'

Please Login or Register  to view this content.

Only when I get rid of the very last ,"" then it works.

Please Login or Register  to view this content.

But when B1 cell is empty, it returns a 'FALSE' on A1 cell.

Is there anything which I have done wrongly? Thanks a lot!

**Richard Buttrey** · 01-10-2016, 03:09 PM

Hi,

It seems there was a parentheses in the wrong place. Try

=IF(OR(B1={"Salary","Cash Deposit","Cashback","Dividend","Interests"}),"INCOME",IF(OR(B1={"Insurance","Dining Out","Groceries","Household"}),"EXPENSE","Unknown item"))

**axangec** · 01-10-2016, 03:33 PM

Originally Posted by Richard Buttrey

Hi,

It seems there was a parentheses in the wrong place. Try

=IF(OR(B1={"Salary","Cash Deposit","Cashback","Dividend","Interests"}),"INCOME",IF(OR(B1={"Insurance","Dining Out","Groceries","Household"}),"EXPENSE","Unknown item"))

Thanks Richard!! It works now!!

**Richard Buttrey** · 01-11-2016, 05:41 AM

Glad to have contributed and thanks for the rep - which is really due to Pepe

**axangec** · 01-11-2016, 06:14 AM

Originally Posted by Richard Buttrey

Glad to have contributed and thanks for the rep - which is really due to Pepe

I added rep for Pepe too, it's people like you guys that make this forums a wonderful place

If function, many ifs but one or two outcome?

LinkBack

Thread Tools

Rate This Thread

Display

If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Re: If function, many ifs but one or two outcome?

Thread Information

Users Browsing this Thread

Similar Threads

IF Function returning text as outcome

[SOLVED] outcome of CONCATENATE function

[SOLVED] why not the same outcome?

[SOLVED] If function Multiple logic tests each with its own outcome. How do I write it.

Linking the outcome of an IF function to a vlookup.

if outcome is less then zero

More than 1 outcome for and IF

Bookmarks

Bookmarks

Posting Permissions