Problem with formula working in 2019 but not in 365

Hi, I am a new member. I am looking for an explanation, why a formula in Excel 2019 works, but does not work in Excel 365, which a friend of mine has. The formula is:

=WENN(C2>0;MINWENNS(Test!$B$10:$B$19;Test!$A$10:$A$19;">="&C2);MINWENNS(Test!$B$10:$B$19;Test!$A$10:$A$19;">="&(C2*-1)))

In my Excel 2019 everything is fine, but he gets #name in his cell. Can it be, that his Excel 365 does not know "MinWenns"? If so, can this be solved?

Is there any chance to write the formula in any other way?

Best regards
KnowNothing
(Germany)

Welcome to the forum.

Excel 365 has everything that Excel 2019 has and more, so that's not the issue.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Please note the forum rules on thread titles: as a courtesy I have updated yours for you this time.