I didn’t know about the CELLS function. Very, very, interesting. I’m going to have to study that in more detail.🧐🧐😁 The LET function is really useful, I love it. Combine it LAMBDA and repeating formulas throughout a workbook is so much easier.
I use a medium sized spreadsheet that I created for estimating construction costs. It has many tabs, well over a hundred named ranges and thousands of instances of many diverse formulas that calculate many many different values needed to determine the final bottom line price for a project. If I were to revise my Range Names and Formulas to utilize LET and LAMBDA functions would this reduce file size? Will it reduce execution time? Does a formula written with declarations execute faster than one that repeats the rote formula over and over?
thanks for this, good explanation of LET and MID
I didn’t know about the CELLS function. Very, very, interesting.
I’m going to have to study that in more detail.🧐🧐😁
The LET function is really useful, I love it. Combine it LAMBDA and repeating formulas throughout a workbook is so much easier.
I use a medium sized spreadsheet that I created for estimating construction costs. It has many tabs, well over a hundred named ranges and thousands of instances of many diverse formulas that calculate many many different values needed to determine the final bottom line price for a project. If I were to revise my Range Names and Formulas to utilize LET and LAMBDA functions would this reduce file size? Will it reduce execution time? Does a formula written with declarations execute faster than one that repeats the rote formula over and over?
Hi? How to insert
hiperlink in the middle of a sentence? Thank you in advance!
I watched for 4 minutes and never saw the payoff. You should start out by showing us why this is going to matter.