IFS

[KirkExcel]

Silly and basic question, but why is this not working?

[#2 · Accepted solution]

@KirkExcel I suspect you are not on Excel 2019 or later. True?

[#3]

Gosh, I do have 2019, but was using 2016 in this instance as currently not on my usual PC. Had no idea it did not work on 2016 - thanks a lot!

[#4]

I'm using school issued excel 2016.

[#5]

@Dana_Herbin So, IFS won't work for you.

[#6]

Thank you. I tried to explain this to my teacher.

[#7]

@Riny_van_Eekelen Show this link to your teacher :)

https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45