ifs() not in office 365

[lezawang]

Hi
I am reading that ifs() is in excel 2016. I have office 356 and I thought it is updated version of 2016.
Thank you.

 

[Joe4]

It is available in Office365 (see: https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45).
Are you sure that you have applied the latet version of Office365?

If you look at the first "Note" in that link, it has a link that shows you how to check/update.

 

[Fluff]

The IFS function is available in 365

 

[MARK858]

Are you sure that you don't have it? It is in my 365.

Excel 2016 (Windows) 64 bit
	A	B	C	D
1	76			Brilliant
Sheet4

Cell Formulas
Range	Formula
D1	=IFS(A1<50,"Poor",A1<=75,"OK",A1>75,"Brilliant")

 

[lezawang]

Thank you all. I have it now! It do not know what happened. I checked earlier, I did not have it. I switch my 365 account and I see ifs() not sure if that is related to switching accounts. But I was very sure why I did =if I only saw 3 options, none of them ifs(). Thank you once again

 

[Fluff]

Glad it's sorted & thanks for the feedback