IFS function not available

Question

Hello,

I need to use IFS function, but it is not available for my Office 2016. Can you tell me why and when it will be available ?

Below i Have the information about my product:

Answer 1

AFAIK there is no such function in Excel 2016.

IF is there, CountIF/CountIFS are there, and other similar functions.

What do you need to do? Maybe that will give us a clue to what you are really looking for.

Answer 2

Hello,

I don't understand your answer "there is no such function in Excel 2016.".

IFS exists: https://support.office.com/en-us/article/IFS-function-36329a26-37b2-467c-972b-4a39bd951d45 . You can find all informations if you access the link....

Delia

Answer 3

From the link you provided;

NOTE: This function is available if you are an Office 365 subscriber and have the latest version of Office installed. It's also available with Excel Online, Excel Mobile, and Excel for Android phones and tablets.

Answer 4

I'm sorry, but you are not very helpful. I have the latest version of software...

It also states that :

which I have. I also checked if I have the latest version, and I do. there are no other update available.

Thank you!

Delia

Answer 5

Well this is the first time in 9 years on this forum that someone feels I have not been helpful... I tried to help. I don't feel bad that I could not... 

Are you a Office 365 subscriber? The link you shared clearly says that you need that... stand alone Excel version does not support IFS.

I also have Excel 2016 and I do NOT have IFS.

I am sure someone else will be helpful. Suggest you create a new post with your question as usually people assume that someone is helping when there are responses.

See https://answers.microsoft.com/en-us/msoffice/forum/msoffice\_excel-mso\_win10/excel-2016-new-functions-ifs-etc/a60615e3-65ed-473b-af16-bf551ac75c9e

Over and out...