Numbers LAMBDA.APPLY: Test Parameters, Missing Values and Formula Results

• Introduced: The original introduction release and date are not established by the checked references. LAMBDA’s separately documented introduction does not prove this helper’s first release.
• Availability: Currently documented in Apple’s Functions Help 15.4 documentation edition; no final supported-version endpoint is established.
• Scope: Shared iWork function reference. Historical iPhone and iCloud availability and exact client parity are unverified.
• Checked: October 14, 2026, against the official LAMBDA.APPLY reference. Examples were independently calculated; no native Numbers test was performed.

Apple prints the single-test-value form:

LAMBDA.APPLY(test-value, LAMBDA(parameter, parameter…, calculation))

The same entry also documents additional test values. Put those values before the final LAMBDA definition, with the corresponding parameters in that definition. The calculation is required and belongs last inside LAMBDA.

For two inputs, the pattern is =LAMBDA.APPLY(value1,value2,LAMBDA(first,second,calculation)). The final argument after the test values must be LAMBDA; Apple says another argument there produces an error. It does not state an exact error-code spelling.

Use parameter tokens, not quoted strings as names. A definition by itself is not enough: Apple’s LAMBDA entry says a bare LAMBDA entered alone in a cell returns an error, and it limits definitions to their own cell and prohibits nested LAMBDAs.

Create AdjustedReadings, with five columns A:E and eight rows, including one header row. Put Reading, Offset, LAMBDA result, Direct result and Difference in A1:E1. Enter these inputs in A2:B6:

In C2 enter =LAMBDA.APPLY(A2,B2,LAMBDA(reading,offset,reading-offset)) and fill through C6. In D2 enter =A2-B2 and fill through D6. In E2 enter =C2-D2 and fill through E6.

Reading and offset must describe compatible quantities; this expression subtracts the supplied offset and performs no calibration or unit validation itself. A negative offset raises the adjusted result, as row 3 illustrates.

In C8 enter =LAMBDA.APPLY(B2,A2,LAMBDA(reading,offset,reading-offset)) for -8. This intentionally reverses the first pair and demonstrates that parameter order is observable. Use D8 for =C2+C8, whose mathematical target is 0.

Apple’s ISOMITTED example tests whether the parameter was passed to LAMBDA.APPLY. Create MissingTemperature, with four columns A:D and six rows. Put 70 in A2, 0 in A3 and 32 in A4.

In B2 enter =LAMBDA.APPLY(A2,LAMBDA(temp,IF(ISOMITTED(temp),"value is missing",(temp-32)*5/9))) and fill through B4.

In D2 enter =LAMBDA.APPLY(,LAMBDA(temp,IF(ISOMITTED(temp),"value is missing",(temp-32)*5/9))). Expect the text value is missing. The empty argument position before the first comma is deliberate and follows Apple’s omitted-value pattern.

That is not a formula referring to a blank cell. Neither an empty-cell reference nor a quoted empty string is substituted for the omitted position in this example. The source establishes the shown distinction; it does not make all blank-looking inputs interchangeable.

Create BlendCheck, with six columns A:F and seven rows. Put First value, Second value, First weight, LAMBDA blend, Direct blend and Difference in A1:F1. Enter these rows in A2:C6:

In D2 enter =LAMBDA.APPLY(A2,B2,C2,LAMBDA(first,second,weight,weight*first+(1-weight)*second)) and fill through D6. In E2 enter =C2*A2+(1-C2)*B2 and fill through E6; expect 80,65,50,20,0. In F2 enter =D2-E2 and fill through F6 for mathematical zeros.

The two weights add to one by construction. With C between zero and one, the result lies between the input values. That interval constraint belongs to this blending model, not to LAMBDA.APPLY’s documented parameter domain. Values outside it would describe extrapolation rather than this convex blend.

To check the symmetric case, put =LAMBDA.APPLY(B4,A4,C4,LAMBDA(first,second,weight,weight*first+(1-weight)*second)) in D7 for 50. Equal weighting hides a swapped-input mistake, whereas the 0.25 row would change from 65 to 35 if only the first two inputs were exchanged. Test a non-symmetric case when checking argument order.

Apple describes LAMBDA.APPLY as unique to Numbers. Its reference says exporting to Excel converts the test to Excel’s LAMBDA(parameter,calculation)(value) form, and importing performs the reverse conversion. Use the Numbers wrapper in these worksheets rather than pasting the Excel testing form unchanged.

This is a specific documented syntax conversion, not a guarantee that every workbook, nested expression, local definition or client round trip behaves identically. No export/import execution was performed for these examples.

These examples use numeric cells, English function names, decimal points and comma-separated arguments. If your decimal separator is a comma, Apple’s functions overview specifies semicolons between arguments. Keep quoted text inside straight double quotation marks when entering the formula.

For a reference to another Numbers table, select the intended cell while editing the formula so Numbers inserts its qualified reference, such as TableName::B2. Do not confuse a local parameter or variable token with a worksheet address. The examples specify complete tables and use separate output columns.

Exact malformed-name errors, numeric-text conversion, extreme-value precision, evaluation timing and cross-client workbook round trips are outside these demonstrated cases. Independently exact arithmetic targets can differ slightly from a displayed spreadsheet result because of finite precision.

See LAMBDA for the definition and its local-scope restrictions, LET for named values, and IF for the conditional result used in the omitted-value example.