Excel / Field note

ETA Reduction for the Common Man

Excel does not treat functions as first-class values—or so it seems. A named LAMBDA can accept MROUND itself as an argument, invoke it later, and return exactly what you would expect. We probe that behavior to learn how far it goes and when it is worth using.

July 26, 2026

Excel does not advertise its functions as first-class values. Yet a named LAMBDA can accept a function itself — not its result — and call it later.

Consider a named LAMBDA with this signature:

VALUE.FMT(NumberValue, DigitsOrMultiple, Function)

It can be called like this:

VALUE.FMT(32.332, 3, MROUND)

MROUND arrives as the Function argument and can ultimately be applied to the other two values. It works just as you would expect. The surprising part is that it works at all.

=VALUE.FMT(32.332, 3, MROUND)

Probe, then decide

One successful formula does not establish the rules. We need to probe which functions can be passed, how Excel handles arity and omitted arguments, when evaluation occurs, and what its errors reveal about the value being carried.

Those experiments will tell us whether this faux first-class behavior is a dependable tool or merely a clever edge case. The mechanism, worked formulas, and findings will follow in the full write-up.