Best explanation I've seen of Let function. Thanks!!
@KILTOPM3 жыл бұрын
You are very very good teacher. Your explanations are crystal clear. Many thanks for your talent.
@alenbastic3 жыл бұрын
As always, very good explanation
@JohnBGood13 жыл бұрын
I want it in Google Sheets so much! Haha
@veljay57933 жыл бұрын
Wow😍 very well explained .. thank u sir it helps a lot to a newbie like Me. 👍
@JohannY23 жыл бұрын
Cool. When will Google sheets get this function?
@PrasadHariharan3 жыл бұрын
Nice video!
@TheRealStevenGlen3 жыл бұрын
That's so cool! Thank you.
@TheRealStevenGlen3 жыл бұрын
I've been wanting this feature for so long
@user-wc9ed7js7n3 жыл бұрын
Thanks a lot
@fhozouri2 жыл бұрын
Great lesson.
@ExcelGoogleSheets2 жыл бұрын
Thanks! 😃
@Name-lt2tz5 ай бұрын
is excel that dump that it repeats the calculation if you do not store it in vairable? it seess same formala, why for it to calculaated twice?
@stevereed5776 Жыл бұрын
Great explanation, thank you. I'm getting to grips with the LET function and starting to really like it. However I created a unique list of some items and store in variable and then tried to use the variable in a MakeArray function that also uses Textsplit to have the text over 3 columns and it does not give the right result. If I replace the variable with the spilled dynamic array (#), it works as it should. Any ideas? Data,MAKEARRAY(ROWS(Flex_ul),3,LAMBDA(rw,col,INDEX(TEXTSPLIT(INDEX(Flex_ul,rw,0)," "),1,col))) - where Flex_ul is the unique list.
@ExcelGoogleSheets Жыл бұрын
Sorry, but the question is unclear to give an answer. But it should work with LET.
@davidfernandezbajo3 жыл бұрын
Amazing explanation, do you think is possible to program a google spreadsheet custom function to achieve the same?
@ExcelGoogleSheets3 жыл бұрын
No. We'll need something from Google Sheets team.
@Name-lt2tz5 ай бұрын
i treid in google sheet. In one cell I wrote =let(kaina, B2, kaina) - and it shows B2 value - ok. Now in anotehr cell I wrote =kaina and it shows #NAME? . It does not see variable in other cells. I want to define the variable once and use it in other cells. How?
@user-ln6jh8tq6f Жыл бұрын
Hello Tutor, please its now available on GOOGLE sheet can you do a video on it?
@afitpacklife8591 Жыл бұрын
Thanks! Is this not ver similar to LAMDA?
@ExcelGoogleSheets Жыл бұрын
Sort of, it doesn't return a function.
@Chanderv318 ай бұрын
11:50
@JeanBrnl3 жыл бұрын
Pleas google make this formula in spreadsheet
@anguschang89943 жыл бұрын
Does let function work the same way in the google sheet as well?
@JohnWick-od9he3 жыл бұрын
Wow. He literally says in the first minute of the video that google sheets doens't have this function.
@insaniah3 жыл бұрын
You can always use Google app script to create new function such as this LET function.
@mr_shanes2 жыл бұрын
@@insaniah do you have a script that does what you say?
@Puner543 жыл бұрын
Sir: Any idea what is Wrong with this Formula: =IF(AND(OR(B2="", B4=""),"", B4-B2), ((ISODD(A1), B4-B2, B5-B3)))
@ExcelGoogleSheets3 жыл бұрын
It's definitely wrong, but then I have no clue what you're trying to accomplish.
@Puner543 жыл бұрын
@@ExcelGoogleSheets =IF(AND(OR(B2 ="", B4 =""), "", (ISEVEN (ROW(A2:A), B4-B2, B5-B3)))) The OR Function looks at Cells B2 and B4 for Numbers. If either is Empty or both are empty then Cell D4 is left empty. AND kicks in If Both B2 and B4 contain Numbers and checks the Row Number for Even or Odd. If the ROW is Even, it executes the Formula B4-B2 in Cell D4 (Row 4) . If the ROW is Odd, it executes the Formula B5-B3 in Cell D5 (Row 5) . Lastly, the Formula should have an ARRAY that Auto Populates the Formula down automatically as Numbers are entered in Column B. Essentially, one can Select Row 4 & Row 5 together, each with a different formula and Drag them down by hand...it would be handy if the process could be automated.
@MuhammadUmair-io5yk3 жыл бұрын
@@Puner54 I think you can start by getting rid of the AND. =IF(OR(B2="",B4 =""),"",XXXX) With the next part of the formula, I'm not sure what you are trying to check ISEVEN for. Which row are you try to check is even? The row the formula is in? or the Top row you are using in the formula (B2)? What are you referencing column A for?
@Puner543 жыл бұрын
@@MuhammadUmair-io5yk... It should look more like this: Cell D4: =ARRAYFORMULA(IF(AND(OR($B$2="",B4=""),"",(ISEVEN(ROW(B2:B),B4-$B$2,B5-$B$3))))) CELL D5: =ARRAYFORMULA(IF(AND(OR($B$2="",B5=""),"",(ISEVEN(ROW(B2:B),B4-$B$2,B5-$B$3))))) Cell D6: =ARRAYFORMULA(IF(AND(OR($B$2="",B6=""),"",(ISEVEN(ROW(B2:B),B6-$B$2,B7-$B$3))))) Cell D7: =ARRAYFORMULA(IF(AND(OR($B$2="",B7=""),"",(ISEVEN(ROW(B2:B),B6-$B$2,B7-$B$3))))) ... and so on down as Data is entered into Cells B2:B.