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
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
RE: Nested If function
Thanks Jens, that works!
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
