FN-COUNTBLANK-001: COUNTBLANK of an omitted optional LAMBDA parameter is #VALUE!
Quirk · measured · recorded 2026-11-04
An optional LAMBDA parameter left out reaches COUNTBLANK as a missing value, and the result is #VALUE!, not a count of 1.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
=LAMBDA([xx],COUNTBLANK(xx))()formula-literal | As typed | #VALUE! | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
Basis: One recorded reading.
Inferred: That this holds for missing values in general is inferred.
Evidence and capture sources
- DnaCalc · crates/calc-func/tests/captures/fn2_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn2_q187
- DnaCalc · apps/dna-onecalc/tests/acceptance.rs 1cccd45a8e55db2363b6afeefa1505fc645d8dbe · recorded_countblank_optional_lambda_omission_is_a_value_error recorded answer pinned
- DnaCalc · crates/calc-func/tests/captures/fn2_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn2_q187, row 20, column 10