Friends, The LET function is available in Excel for Microsoft 365 for Windows and Mac, and Excel for the web. The function was gradually rolled out from July 2020. Do note that the LET function may not be available to you yet if you are not a Microsoft 365 subscriber.
Hello sir may I request to know course of data science and data analysis. Which one is the best course and course price? which education need to complete to do it course?
2007 ki kuch formulua 2019 office kaam nahi karta jaise data validation me up - down list ek sheet se dusre sheet me copy nahi hota .....iss jaise pe ek video bana sakte hai ki kon kon sa formaula kaam nahi karta aur karega to kaise karega....
Sir excel ki auto invoice me jaha item name ki drop down list bnate he un cells par click karne par ek button open ho just par click karne par hum usi sheet par pahunch jaye jha hame item add karna he please istrah ki invoice babnane me meri help kare please please
It is very good formula. I have make a file which have so many variable. Tommorrow, I will change my formula to let function. I hope that file will give result in less time. My file has about 1000 of columns and thousans of Rows. I am not awaire about vba due to this facing problem to solve /analysis on long databae. Initially I alrady give the formula in about 10 K rows due to this file size becomes large. If, I may use vba and formula will autofill in Rows and columns a large number of space will save. If possible suggest VBA
I have created a macro enabled excel sheet to transfer data to another sheet,can you please tell me that when no data is entered and we click on save data then in data sheet one blank row is created is there any solution for that? Please respond
@deepak bhai Mehne bahut office meh dekha hai woh log double click karke apna putty session le lete hai same execl sheet pr rahete hu woh kaise hoga kindly resolve it bro
Sir Apne wala (jo ap use kar rahe) Microsoft excel google drive link me de den or plz install karna be sekha den. Plz ye jaldi karen.ya software de den.
Problem is Let formula is more complex than other shown formula... It doesn't seems to be useful in given example. Sorry if you didn't like the Comment 🙏
Actually I want to make RUclips channel about ms office. So Kiya Jo cheezy ma ny ap K chanel sy learn ki ha ms office K bary un K bary ma videos bana skti hu. Is ma copy right ka problem to ni ho ga. Ap kiya advise krty ha?? Plz reply,
Very nice let formula save time long written formula it is very useful for multiple calculation thank you sir
Thanks for sharing it. This formula : =LET(avg,AVERAGE(C4:E4),IF(avg>79,"A",IF(AND(avg=50),"B",IF(avg
Ye to seedha cell reference se bhi aasan h krna
Friends, The LET function is available in Excel for Microsoft 365 for Windows and Mac, and Excel for the web. The function was gradually rolled out from July 2020. Do note that the LET function may not be available to you yet if you are not a Microsoft 365 subscriber.
Sir how to create you your thumbnails
Pls make video on ms access full (like ms word ) sir ...
Ur teaching method are so good..
Pls do it....
You are great , the way you explain is easy for a novice guy. Thank you !
Well explained concept.
Sir aap bhaut aache se samjate he..❤️❤️❤️❤️❤️❤️❤️
Superb bhai, I love your teaching style. I learned lots of things in excel.
When i see your video, i just like before watching it, because your videos always very useful
Ye sir bhut acha pdhte he...
Mne inse class li he palwal hartron institute me
🙂
@@DeepakEduWorld agra chowk hartron institute palwal
Your videos are full of learning and very easy to understand. You are a great trainer. Thank you for sharing valuable learnings.
Aap jo formula batate ho jaise ki let,xmatch ye excel 365 me bhi ni hai. To aap ke excel me kaise aate hai yani ki aap kaun sa virson use karte ho
Dear Deepak
Explanation good......but plz tell us shortcut keys of the command u used in each vedios also.....it An humble request
Deepak ji,
Aapka samjhane ka tarika bahut accha h...
Waooo
Super Se B Uppar Video
Guru ji
What a nice tips! Just Wow. My lovely & Dear Dada....................
thanks dear.. from PAk
Deepak Bhai yeh batao execl meh table ko double click karke direct putty session kaise le
Well explained 👏
Great effort sir
I am salute to you
Very useful & helpful excel formula, thanks for making such a informative video 👍
Maza aagaya sir
Its, sumifs bhi use kr saktey hai hum
Can you please help me with most useful Advance excel formulas for data analysis.
Very Nice Sir
Ye Sab Office 365 Me Hi Q Dete H, Sabhi Versions Me Q Nahi Dete???
Hello sir may I request to know course of data science and data analysis. Which one is the best course and course price? which education need to complete to do it course?
Sir aap kamal ke ho 💯
Excellent sir
Very nice
Aap Office 365 use karte hai ms office ka latest version ?
Genius great sir.....stay safe....
Thanks Deepak bhai
May use IFS formula insted of IF
Sir microsoft word pr full ek video banao phone me 😳
2007 ki kuch formulua 2019 office kaam nahi karta jaise data validation me up - down list ek sheet se dusre sheet me copy nahi hota .....iss jaise pe ek video bana sakte hai ki kon kon sa formaula kaam nahi karta aur karega to kaise karega....
Very useful
Average निकालने के लिए simplest formula है =average(range)
=SUBTOTAL(101, range)
=SUBTOTAL formula में और भी बहुत options हैं।
Great work 👍
Great....👍👍👍
Sir excel ki auto invoice me jaha item name ki drop down list bnate he un cells par click karne par ek button open ho just par click karne par hum usi sheet par pahunch jaye jha hame item add karna he please istrah ki invoice babnane me meri help kare please please
Thinks sir
Very nice sir
Sheet 4 ke example me, sales ke figures ke neech, eek baar sum ka formula lagake IF THEN ELSE use karenge, to bhi sum ek baar hi hoga.
It is very good formula. I have make a file which have so many variable. Tommorrow, I will change my formula to let function. I hope that file will give result in less time. My file has about 1000 of columns and thousans of Rows.
I am not awaire about vba due to this facing problem to solve /analysis on long databae. Initially I alrady give the formula in about 10 K rows due to this file size becomes large. If, I may use vba and formula will autofill in Rows and columns a large number of space will save. If possible suggest VBA
I have created a macro enabled excel sheet to transfer data to another sheet,can you please tell me that when no data is entered and we click on save data then in data sheet one blank row is created is there any solution for that? Please respond
Sir
Pls post video on Solver in MS excel
Can u learn VBA coding in Excel, plz
Thank you bhai 👍
@deepak bhai
Mehne bahut office meh dekha hai woh log double click karke apna putty session le lete hai same execl sheet pr rahete hu woh kaise hoga kindly resolve it bro
Sir Apne wala (jo ap use kar rahe) Microsoft excel google drive link me de den or plz install karna be sekha den.
Plz ye jaldi karen.ya software de den.
Ek chij hai vo sikhaye sir comment kro to btata hu bhut hi achi cheej hai
LET formula kaun se version mein hota hai?
Office 365 me hai abi
great work
Sir please resume kaise banaya us topic par video Bana dijiye
Mujhe ek party ke name se multiple warehouse name aur unki qty chaiye
To kaise kr skta hu mai ussey
सर, 85000/2-40℅ को एक्सेल फॉर्मूले में कैसे लिखेंगे ? मतलब 85000 /2= 42500 , 42500 में 40% घटाने पर उत्तर 25500 आये।
Mind blowing sir 🙏🙏🙏
Not working in office 2016, is it working in 2019 or only in 365
Appreciable
Let function ni aara sir formula me , enable kese kru
Super
Good 👍
Hello bro Excel mai gaer ham 10 sheets ko ek Buttom add karte h to fir usi data ko clear kar ke 2nd Buttom mai data add kese. Kre plz reply me ..
SIRJEE MERE PASS MS EXCEL 2010 VERSION HAI. KYA HISSE AA SAKTHA HAI KYA
Kindly do let fn with vlookup,xlookup
Excel sheet ka upper cell ka data ko lower cell main copy karneke liya ctrl D press karte hai to word main kya karna chahiya....
"LET" begin this topiccc🥰
Chaliye shuru karte hai👆👍
🤗🤗🤗
@@DeepakEduWorld Thank You Sir💐🥰
Please provide the practice file too
Problem is Let formula is more complex than other shown formula...
It doesn't seems to be useful in given example.
Sorry if you didn't like the Comment 🙏
Useful information but unnecessarily making the video lengthy.
Sir tally ERP 9 nhi padhate h kya
Nahi ji
I am using Microsoft 365
Sir kya LET function 2016 me available he
Great when u use this function with multiple like
Vlookup,if, really u'll be stress less
Sir muje A, B, C column ki multiply krke or ans se 5% less krna h to kse hoga
=A1×B1×C1-5%
Sir please share excel sheet ... for practice
Sir data validation ka shortcut keys betao
Sir, this function is not avilable in office 365.
𝙏𝙝𝙖𝙣𝙠❤🌹🙏 𝙮𝙤𝙪💯🤜 𝙎𝙞𝙧
How can i contact with you brother
Boss why we are not using ‘IFS’ In place of “IF”
VBA me code karna bataw bhai plzz
Thanks sir ye fourmula sir excel 2010
Me kam karaga sir window 7 me sir please reply sir 😀😀🙏🙏
Kam karega
Bhai mere Excel me let function nahi hai kaise laaye
Sir koi video banyo 100 formula ki ak hi video m
👍❤️👍❤️👍❤️👍❤️👍❤️👍❤️👍
Let is not showing in my exle
Sir excel me school management system me students fees & teachers payment setup banaye pls 🙏🙏🙏
Let formula nei aaya excel 2019 me
Sir kisi number ko round number me kaise convert kare jaise 33175 to 175 ya 200 ho jaye ya 100 ho jaye
Roundup
@@mohammadnaseem5091 sukriya Bhai
@5.25 sum(x, y) not sum(x+y)
bhai xloocup mery pas shwo nahin horha excal 2019
Wo excel 365 me hi dikhega kisi aur me nahi
LET formula work nhi karta Ms2007 mein
Sar kya aapka WhatsApp number hai
Excel file send karni thi aapko
Ye formula itna kaam nahi ayega if se hi ho jayega
Video clean nhi hai sir g
Pehle like kare fir video dekhe
Thora Kom baat Karen
Explaining and Understanding is important
Pls appreciate his eagerness to give knowledge
Sir Plz response
Actually I want to make RUclips channel about ms office. So Kiya Jo cheezy ma ny ap K chanel sy learn ki ha ms office K bary un K bary ma videos bana skti hu. Is ma copy right ka problem to ni ho ga. Ap kiya advise krty ha?? Plz reply,
Reply please
@@allahsblessingsformankind9475 no copyright issues hoge video pr
Samjh m nhi aaya 😔😔
Complicate & worst formulation.