Issue with Excel formula and OneDrive name that includes a comma

[Kimber]

Yikes! Just had another issue come up. I am sorry if my description is confusing.

We use OneDrive, so the other file that my cells are linked to has our company name in it. One of the total cells was returning an average where there was only one value. When I analyzed the new formula that uses ISNUMBER (and theoretically would have the same issue with any if/then formula) Excel "thinks" the end of my argument stops at the comma in our company name without getting to the actual cell reference. I assume Microsoft uses our legal corporate name, so does anyone know of a workaround for my formula?

 

[Chihiro]

Will need to see the actual formula to help you.

Replace sensitive info with generic string, while keeping formula structure the same and post.

My guess, is that you are missing "'" (single quote) in in front of "https://" or at end of sheet name (before "!").

Edit: See below for an example (replaced company name).

=IF('https://mycompany365-my.sharepoint.com/personal/chihiro_companyname_ca/Documents/[Analysis.xlsb]Data'!$A$143="Fort Worth", "Blah",0)

URL may differ from company to company, but if you open the file from OneDrive to edit in Excel, when you make the link and close the workbook on OneDrive, formula should automatically adjust to add URL needed.