Understand complex syntax in calc

I’m trying to convert a complex formulated Calc file into a python program and database. I want to understand it’s syntax better. Is there any tool to understand the syntax better?
For example, one of it’s functions is this:


I want to understand what it is doing.

Perhaps viewing it with the function wizard, is more understandable.

I think what it does is return the column M value for the first value in column C equal or greater than G8.


With another tool you can get intermediate calculations.
Principle is to select the relevant part of the formula and then press the F9 key. The result is displayed in a tooltip.
This works both in the formula bar and in-place editing of the cell.
A short video shows this feature. It is in French but the demonstration should remain understandable.