More than two answers: IFS

IFS checks tests in order and returns the first match: =IFS(test1, answer1, test2, answer2, …). Use TRUE as the last test for “everything else”.

4 exercises in this lesson are part of ExcelHero Pro.