Missing Excel Functions in Excel Online

Question

There are several articles regarding specific functions in Excel that are missing and/or don't work in Excel Online (e.g. CELL, IFS, etc.). However, after a quick search, there doesn't appear to be a side-by-side list of functions that are in the Excel desktop app and not in Excel Online. Is there such a list? Do I need to make one?

My question: Where can I find a side-by-side list of Excel functions that are in the desktop app but not in the online version?

Answer 1

Hi John,

Thanks for the replying back with more detailed clarification. I searched and tested more about this problem you mentioned about. Please kindly check below.

Refer to the function feature introduced in Excel for the web, You can use most of the more than 400 Excel worksheet functions in formulas in Excel for the web, including functions used in dynamic array formulas, such as the FILTER function.

 

There’s no official article or list mentioning any function that not supported in Excel for the Web. Only the list of the difference for the list of the functions work between Excel for the web and client app.

And based on my test, for the IFS/CELL/CHIDIST/CHIINV, they are all supported in Excel on the web. Please kindly check my test screenshots below.

 

Currently, I haven’t found any function that totally not supported in Excel for the Web. To double confirm that, I have also found official article for these functions, for example, CHIINV function, it states that the function applies to Excel for the web.

 

Do you meet any issues when you use any of them in Excel for the web? If so, you can provide us the screenshot and detailed steps and problems, I can investigate further for you.

Regards,

Rena

Answer 2

Hi John,

Do you still have further problems about the Excel functions between web and client? You can post back any time if you still need my help.

Regards,

Rena

Answer 3

Hello Rena,

Sorry for the delay.

Yes, I do still experience some issues. Here's the listbox for functions on my computer:

Notice that "CELL" isn't on the list. Also, typing the function in manually gives me a #VALUE! error. Here is a screenshot of what happens.

So I'm confused why it works on your computer, but not on mine (or ours--nobody in our company is able to use the CELL function in the online version of Excel). I have gone through the online list on my computer. I have found IFS, but not CELL, CHIDIST or CHIINV. They are not on my list.

That's for your information. You have answered my question, so "Thank you".

Take care,

John

Answer 4

Hi John,

Nice to hear you back.

For the CELL function, refer to CELL function, the “filename” info_type” is not supported in Excel for the web, Excel Mobile, and Excel starter. This is a very specific restriction to this info_type. If you change the info_type to another one, for example, “address”, you will find that it works in Excel for web.

 

Additionally, they really do not show up directly in the list, but manually typing will make them work based on my test.

Regards,

Rena

Answer 5

Hi John,

Haven't heard from you for a few days. Have you checked the information above for the cause of the formula error you meet when you use the CELL function in Excel on the web? Hope the information can help you. If you still meet any other problems when you use the formula in Excel on the web, you can also post back. I will try the best to help you.

Regards,

Rena