Nested If function

Resolved · Medium Priority · Version 365

Wed 24 Aug 2022, 15:07 Delegate Mohammed said...

Mohammed has attended:
Excel Advanced course

Nested If function

Hi I am trying to use the IFS function to basically narrow down countries into regions. I've been able to using just IFS in the past but wanted to try using the OR function to make it a bit quicker.

At the moment I only get a return on the first logical value, this is my formula:

=IFS(OR([@[Account Description]]="TRAVEL HOLLAND","TRAVEL FRANCE", "TRAVEL GREECE", "TRAVEL ITALY", "TRAVEL EUROPE GENERAL", "TRAVEL MONACO", "TRAVEL SWEDEN","TRAVEL DENMARK", "TRAVEL NORWAY",), "Europe", OR([@[Account Description]]="TRAVEL U.S.A.", "TRAVEL CANADA","TRAVEL BERMUDA"), "USA/CANADA")

Thanks in advance

Wed 24 Aug 2022, 15:26 Trainer Jens said...

RE: Nested If function

Hi Mo,

Thank you for the forum question.

Try:
=IFS(OR([@[Account Description]]="TRAVEL HOLLAND",[@[Account Description]]="TRAVEL FRANCE", [@[Account Description]]="TRAVEL GREECE", [@[Account Description]]="TRAVEL ITALY", [@[Account Description]]="TRAVEL EUROPE GENERAL", [@[Account Description]]="TRAVEL MONACO", [@[Account Description]]="TRAVEL SWEDEN",[@[Account Description]]="TRAVEL DENMARK",[@[Account Description]]= "TRAVEL NORWAY",), "Europe", OR([@[Account Description]]="TRAVEL U.S.A.", [@[Account Description]]="TRAVEL CANADA",[@[Account Description]]="TRAVEL BERMUDA"), "USA/CANADA")

You will have to reference [@[Account Description]] for each.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 24 Aug 2022, 15:39 Delegate Mohammed said...

RE: Nested If function

Thanks Jens, that works!

Wed 24 Aug 2022, 15:41 Trainer Jens said...

RE: Nested If function

Hi Mo,

You are welcome. Happy to help.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips