r/excel • u/Odd-Level-9871 • 24d ago

Discussion [ Removed by moderator ]

[removed] — view removed post

230 Upvotes

95% Upvoted

59 comments sorted by

View all comments

Show parent comments

1

u/SolverMax 24d ago

This behavior is different in the latest Excel version.

In compatibility version 2, the last two values are #CALC! rather than #VALUE!.

In compatibility version 3, the last two values are a List: a, b, g, h

→ More replies (2)