Excel Version on Two Different PCs Changes Formulas???

[boss429cj]

Hello!

So I have a tracking sheet that I use record some games stats for my group.

Oddly, when I open the file on one PC, it opens as normal and no issues.

However, when I open it on another PC, it messes with one of the formulas. I cannot figure out why?

They are different versions, the one with a newer version is the one with the issue.

I am attaching the file with the actual formula, however, not sure how it will open on anyone else's PCs.

I am also attaching some screenshots to show the discrepancy.

Thoughts??

[alansidman]

I am opening the file in 365 version 2206 and it appears with no issues. This is a later version than the one you are showing in the word doc.

[Fluff13]

However, when I open it on another PC

Are you sure that the other PC is using xl 365 or 2021?
The xlfn denotes that the formula is not supported.

[boss429cj]

Thank you guys for your responses. The strange thing is I have used the file on both PCs in the past, so it must be that one of them updated to a later version and something changed in the support.

I understand now what the xlfn means.

Might have to look into an update. Thanks again!

[Fluff13]

It's probably the Sequence function that is causing the problem & that has been around for awhile, are you sure the formula has not been changed?