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,

Here’s an official article including the difference between them. Refer to Differences between using a workbook in the browser and in Excel, Most Excel functions work in a browser window as they do in Excel. Exceptions are listed in the Workbook functions section of this article.

 

For the CELL and IFS function, they work fine based on my test in Excel Online. And they are not in the list above. They should work fine. If you meet any problems when you use them, you can provide us some screenshots and more detailed descriptions, we may test and help you.

Regards,

Rena

Answer 3

Thanks, Rena.

However, this is a list of "differences" between the 2 versions--it is text-based and not very visually understandable.

To rephrase my question and make it more precise: Is there a table representation of the differences in functions available in the Excel Desktop App and Excel Online like the following:

Function	Excel Desktop App	Excel Online
SUM	X	X
IF	X	X
IFS	X
CELL	X
AVERAGE	X	X
COUNTIF	X	X
CHIDIST	X
CHIINV	X

The purpose of such a table would be to allow me to check a function before I use it to make sure it will work in both operating environments.

So, is there such a listing? I've looked--but I'm older and not very "search savvy."

Answer 4

Hi John,

Just kindly remind you not contacting any number provided in this Community Forum to protect yourself. They may ask money or privacy information while they pretend to help you solving problems. No support engineers or moderators will ask these from you.

Regards,

Rena