Search notes:

Excel function: let

The Excel function let allows to declare variables and then use their values within the function.
Assign 17 to x, 13 to y, then calculate x*y:
=let( x; 17 ;  y; 13 ;   x*y )
It's possible to assign the returned value of an Excel function to a variable.
Here, the string "Hello world" is assigned to txt, then the length of that string is evaluated with the function len() and assigned to the variable txtLen, finally, a string which is assembled of text constants and the values of the variables is returned.
=let( txt; "Hello world" ;  txtLen; len(txt) ; "The length of '" & txt & "' is " & txtLen )

See also

Excel worksheet functions

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1758201193, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/functions/let/index(47): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78