From 4167f524c4718c3960cae2e4f390d04ffdb20839 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Thu, 6 Jun 2024 16:44:57 -0300 Subject: tdf161442 Help page for Calc LET function Change-Id: I81a5304786f626eaf7b556bb5faf6fa90f2eab34 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168508 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/func_let.xhp | 48 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 source/text/scalc/01/func_let.xhp (limited to 'source') diff --git a/source/text/scalc/01/func_let.xhp b/source/text/scalc/01/func_let.xhp new file mode 100644 index 0000000000..610d883248 --- /dev/null +++ b/source/text/scalc/01/func_let.xhp @@ -0,0 +1,48 @@ + + + + + + + LET function + /text/scalc/01/func_let.xhp + + + + + +LET function + +

LET

+ Assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function. +

+LET(Name1; Name_value1; Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]]) + +Name1: the first name to assign. Must start with a letter. Cannot be the output of a formula or conflict with range syntax. +Name1 must follow the naming rules of %PRODUCTNAME Calc. +Name_value1: the value or calculation to assign to Name1. +Name2; Name_value2;...: (optional) same as Name1 and Name_value1, respectively. Name_value2 must follow Name2 and so on. +Calculation: a formula expression that uses all names within the LET function. +Calculation must be the last argument in the LET function. +

+Calculate the molar mass of the water molecule knowing that the molecule has 2 hydrogen atoms and one oxygen atom. +=LET(mHydro; HLOOKUP("Hydrogen"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP("Oxygen"; $A$1:$DO$4; 4; 0); "The molar mass of water is "&(mOxy+2*mHydro)&" g/mol") returns "The molar mass of water is 18.015 g/mol". +

+COM.MICROSOFT.LET +

+ LET wiki page. +

+ + -- cgit