LET in WPS Spreadsheet: Name Intermediate Results in a Formula

The official WPS Academy LET lesson, dated February 2, 2024, identifies Chinese WPS Office for Windows Personal. Its video shows the argument tooltip, local-name explanation and a completed lookup-and-grade calculation. That establishes a documented use case, not the first release or support in every Windows build, global-English edition, Mac, mobile or web client.

The source was checked on October 19, 2026. The original examples below use independent arithmetic and lookup checks; they were not executed in a current WPS installation. Exact introduction and last-supported versions remain unestablished.

The observed WPS tooltip expresses the expandable structure as:

LET(name1, name_value1, calculation_or_name2, [name_value2, calculation_or_name3, ...])

For one named value, write =LET(name,value,calculation). With two named values, the pattern is =LET(name1,value1,name2,value2,calculation). Every name must have its corresponding value or expression; the last argument is the expression whose result you want returned. Brackets and ellipses describe the syntax and are not typed into a worksheet.

• A name is an identifier used inside this LET call.
• Its value can be a literal value, a cell reference or a calculation.
• The final calculation uses those names to produce the result.

The demonstrated dialog says these names are local to LET. The source’s naming guidance calls for a letter-leading name that does not conflict with range syntax. The examples use simple identifiers such as x, quantity, price and score. This is not a complete catalogue of permitted identifiers or argument-count limits.

Create a sheet named Costs. Put Quantity, Unit price and Discount in A1:C1. Enter 12, 2.5 and 10% in A2:C2.

In E2 enter:

=LET(quantity,A2,price,B2,quantity*price)

Independent expected result: 30. The name quantity refers to A2, price refers to B2, and the final multiplication uses those two values. The shorter =A2*B2 is perfectly adequate for this small calculation; LET becomes more useful when intermediate expressions are longer or repeated.

In E3 enter:

=LET(gross,A2*B2,gross*(1-C2))

Expected result: 27, since 30 × (1 − 0.10) = 27. Gross is the pre-discount amount, not the final total. If C2 is entered as 10 rather than 10%, the arithmetic is different; naming the intermediate result does not correct an incorrectly stored rate.

For a quick independent check, change only A2 to 8. E2 is then expected to be 20 and E3 18. Restore A2 to 12 before continuing if you want to retain the original control.

Create a separate sheet named Grades, so this dataset does not overwrite Costs. Put Name and Score in A1:B1, then enter:

Put B in E2. In F2 enter:

=LET(score,VLOOKUP(E2,$A$2:$B$8,2,0),IF(score>=90,"Excellent",IF(score>=80,"Good",IF(score>=60,"Pass","Review"))))

Expected result: Review, because the exact lookup finds 58 for B. Changing E2 to A gives Good; changing it to D gives Pass; changing it to E gives Excellent. These are original English labels applied to the same threshold structure demonstrated in the WPS lesson.

VLOOKUP supplies the score. Its fourth argument is explicitly 0 for the exact-match exercise. IF then tests the score from the highest threshold downward. Testing score>=60 first would wrongly label every higher score as Pass unless the logic were reorganized.

The official video uses a named lookup result and Chinese grade labels; its completed B/58 example shows the failing-grade label. The table above is a reproducible English adaptation with its own stated cell addresses, rather than a claim that these English formulas were captured in that video.

On another empty area, enter =LET(x,5,x*3) in J2 and =LET(x,10,x*3) in J3. Their expected results are 15 and 30. Reusing the identifier x in another LET call does not make the first formula’s value a shared workbook variable.

For a reusable callable calculation, see LAMBDA. LET names intermediate values within a formula; a named LAMBDA can expose parameters that another formula supplies. These are different purposes, even when both improve readability.

• The argument sequence is hard to follow: pair each name with its value, then identify the final calculation. Do not leave a newly added name without its value.
• A lookup fails: inspect the source key and VLOOKUP separately. LET does not automatically replace errors with a default or make an absent key valid.
• A copied formula reads the wrong table: keep the lookup range absolute, as in $A$2:$B$8, and decide deliberately which input references should move.
• A name is rejected: use a simple letter-leading identifier and check the installed editor’s naming guidance. Do not assume all names accepted by another spreadsheet are valid here.
• LET is not recognized: check the actual installation and edition. A dated Windows Personal lesson does not establish every client or old build.

The lesson describes reducing repeated expressions, but no performance benchmark was measured for these examples. Readability is visible in the formula; a claimed speed improvement needs an actual workload test. Maximum argument counts, unusual coercions, localized parsing and precise malformed-input error codes remain outside the verified contract here.

• Official WPS LET lesson.
• Official lesson video: tooltip and local scope around 65 seconds; completed lookup around 70 seconds.