I’ve hardly watched any videos throughout, but Deepak’s videos are so clear and easy to understand that I’ve learned most of Excel from him. Much respect and best wishes to him!
Sir ji your videos are very useful for us the teachers in many ways like attendance sheet, result sheet, MDM calculations etc. Thanks 🙏🙏 Suresh Ram ETT teacher Government Elementary Smart School Sassi Brahmna cluster Bibipur Block Samana, Patiala Punjab India
Need formula in excel please help, who is genius, please solve and update a new function in excel. As I needed. A1 = 10 A2 = 0 A3= (Condition applied) My condition if A1>A2 then value in A5 is =A1 value as it is.
I have a question regarding application of formula/function. My question is, how is it possible to create a sheet with VBA using the formula I am using in any cell of Excell? For example, in cell A2 I want to print the present age of a person, for that I have to use a formula in that cell, but that formula I want to use in VBA. How to write the formula in VBA?
कृपया गुरुजी परीक्षा मे बैठक व्यवस्था हेतु एक्सेल शीट कैसे बनाएंगे बताने की कृपा कीजिये। Respected sir kindly make and advance exams seating pattern in Excel in which when we will and start insert the number of students in a row then roll number automatically shift into the another line.
Hello sir ,y formula to apply ho jata h but jb hm original list delete krte h to jaha formula apply krk mr,miss add kiya h wo b delete ho jati h uske liye kya kre pls reply sir
If the value is 1 to 60 then 1, if value is 61 to 120 then 2, if value is 121 to 220 (for 100 numbers) then 3 and continue....4,5,6... Then what is the if formula...?
Iska formula excel me batao to janu apko master. A1 = 10 A2 = 0 A3 A4 A5= (Condition applied) My condition if A1>A2 then value in A5 is =A1 value as it is(=10).
दिपक जी नमस्कार, मैं नागपूर, महाराष्ट्र का रहिवासी हूं मूझे बताओ की एक्सेल शीट मे प्रेझेंट , अबसेंट और हाप डे वाले एम्प्लॉइज को कैसे ढूंडनआ उसके लिये फॉर्म्युला बताओ.
marksheet mei agar condition ho ke 2 subject mein passing marks se kam ho to compartment lika aaye , aur 3 ya isse jada wala fail to ye kaise hoga? pls reply.
2 sheet mei agar 1 value jo sheet 1 mei Column A mei kahi bhi hai to True and nhi hai to false. chahe Sheet 1 ke cell A2 wali value Sheet 2 ke A31 cell mei hai to bhi true or poore A column mei nhi h to false. ye kaise banega formula
I am placing/writing a formula in cell C1 In A1 - Its EXPIRY DATE In B1 - Its RENEWAL DATE =IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT") The above formula is working. Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()
Sir , kya eise kuchh formula hai jise hum el number ki bich wala zero ko hata sakte hai . Example - ek cell me hum 531096 likhe and formula laga hua cell me 53196 show ho .
PLEAES RESOLVE BY IF FORMULA ID DATE RESULT 1001 25-08-2024 1 1001 26-08-2024 2 1001 27-08-2024 3 1001 28-08-2024 4 1002 29-08-2024 1 1002 30-08-2024 2 1003 31-08-2024 1 1003 01-09-2024 2 1003 02-09-2024 3 PL SUGEST "IF" FORMULA FOR RESULT AS 3rd column
Sir ek question hai Meri company me 10 employee hai jisme mene unko target diya hai agar vo 5 lakh se jyada sales karte hai to me unko 5 lakh pe 0.5% incentive duga or agar vo 10 lakh se jyada sales karte hai to me unhe 10 lakh ki amount pe 1% incentive duga to me use Excel me kese formula lagake pata karu ki kisko kitna incentive milega or muje 1 hi row line me jankari chahiye ???
दीपक सर मै आपसे निवेदन करत हॅू कि ( हिन्दी ) में एक Drop डाउन लिस्ट बना दीजिए । ईगलिश मे जो आप Drop डाउन लिस्ट का विडियो बनाकर अपलोड कियें थे सर जब वो Word Delate करते है सर Drop down list से भी हट जाता हैं । ये जानकारी मुझे अभी तक किसी भी यूटूब चैनल पर नही है । एक बार हिन्दी मे ड़ॉप डाउन लिस्ट बनाकर सही से explain कर दिजीए सर ।
Tum bhulte isliye ho ki tumko Excel me interest he nhi hai. Aur Excel Sikh ke job he kyu karna. Excel teacher bano youtuber bano. Bahut option hai but tumko sikhna he nhi hai. tum study me politics mat ghusao nhi to tum ghus jaoge.
Itna badhiya samjhane Wale teacher tumko kabhi Mila bhi nhi hoga. Aur agar phir bhi samajh me na aaye to tumhare dimaag me gobar bhara hai. Beta tumse na ho payega.
@@nomadtales_11 yha competition karne ka bat nhi kar rha. Tere se Kam he janta hu lekin ek multinational company me working hu. Phir to tere se better he hu n main. Aur tu anab sanab bole ja rha hai comment me.
![[#2024MAMA] ROSÉ (로제), Bruno Mars - APT. | Mnet 241122 방송](http://i.ytimg.com/vi/dgGqD28J6aQ/mqdefault.jpg)
I’ve hardly watched any videos throughout, but Deepak’s videos are so clear and easy to understand that I’ve learned most of Excel from him. Much respect and best wishes to him!
Ak baar me hi samajh me aa jaye kuch aisa tha experience 🙋 thanks keep teaching
th-cam.com/video/lvSyVqzABTM/w-d-xo.htmlsi=8khXtYGETKDyZ5Oo
One of the best channel on TH-cam ❤
thanks for sharing informative video
Very informative especially if and formula. Thnx
Win +. For symbol, learned something new
bahut hi beautiful videos
Deepak bhai please ek series start karo jisme hum Ai ki help se excel use kare
Video Bahu Achcha Laga Sir.
Very good teaching brother
Nice sir Thank you so much,
TH-cam pr best chenal brother
❤
th-cam.com/video/lvSyVqzABTM/w-d-xo.htmlsi=8khXtYGETKDyZ5Oo
सचमे बढिया विडिओ सर 👌👌
DEEPAK SIR YOUR TEACHING IS VERY GOOD
Best tutor ... Providing practice file also.. Thank you so much sir.
Thank you so much, brother. Today I learned how to get smiley with press window and dot..
Great 👍
❤ Best Tutor on TH-cam...
Valuable information for me, thanks a lot,
Nice video
Plz upload subtotal video
Mast video 👌Aise or bhi formula ke videos banao sir
Deepak Sir, you are. awesome ❤❤
LOVE FOR YOU SIR YOU ARE KING OF EXCEL(I AM FROM PAK )
Many thanks
Sir ji your videos are very useful for us the teachers in many ways like attendance sheet, result sheet, MDM calculations etc. Thanks 🙏🙏
Suresh Ram ETT teacher Government Elementary Smart School Sassi Brahmna cluster Bibipur Block Samana, Patiala Punjab India
@Exceldelhiwala channel pe advance if formula hy..
80+ hours ka
Pdf provided by yours is very very helpful and your teaching style is also ausm ❤
Pdf kaha ha😢
Need formula in excel please help, who is genius, please solve and update a new function in excel. As I needed.
A1 = 10
A2 = 0
A3= (Condition applied)
My condition if A1>A2 then value in A5 is =A1 value as it is.
Thanks a lot,!!! Subscribed!!!
Wonderful Sir 👍❣️
Awesome sirjee... It was nice feeling to watch your video
lajawab videos
th-cam.com/video/lvSyVqzABTM/w-d-xo.htmlsi=8khXtYGETKDyZ5Oo
Thank You So Much
You have good psce of teaching(explaining).Friendly to understand.Assents comfortable to understand ,Good going.My personal thanks👌👍
Deepak sir ek besic to advanced tally+Excel+ms word.
❤loving your videos
U r best
Thanks you sir.
for special paste use alt+ctrl+v
Thxx uhh sir 🙏
Very good video
very good. 👍️👍️👍️👍️🇳🇵🇳🇵🇳🇵
nice video sirji ...apka koi excel ka advance paid course hai to bata dena ji...
Deepak Sir ek doubt hai If kaa use karke kya hum previous volume ko minus karte hue add on kar sakte hai
Sir
And wala Thora hard laga
I have a requirement where OR , AND need to be combined.. do you have any videos on ifs(and(OR)).. scenarios?
So good
Sir aap say request hai yak bank statement ka PDF file ka yak video banaye jismi sumif, filter ka use karke bataye
Super
Thanks
🥰
thanks alot
deepak sir exel vba cheak box par video banaye
Ex 9 ka formula
=if(min(c3:c5)>=40,"pass","fail")
I have a question regarding application of formula/function. My question is, how is it possible to create a sheet with VBA using the formula I am using in any cell of Excell? For example, in cell A2 I want to print the present age of a person, for that I have to use a formula in that cell, but that formula I want to use in VBA. How to write the formula in VBA?
Sar ek per day collection Lene wali seat banaaiye jismein with penalty daily payment receive kar sake 6 mahine se lekar 1 sal 2 sal 3 sal Tak
कृपया गुरुजी परीक्षा मे बैठक व्यवस्था हेतु एक्सेल शीट कैसे बनाएंगे बताने की कृपा कीजिये।
Respected sir kindly make and advance exams seating pattern in Excel in which when we will and start insert the number of students in a row then roll number automatically shift into the another line.
Hello sir ,y formula to apply ho jata h but jb hm original list delete krte h to jaha formula apply krk mr,miss add kiya h wo b delete ho jati h uske liye kya kre pls reply sir
Hi brother
Ek video banavo jisme Photographer booking, price, count automatically show kare kitna bookings huva, kitna payment aya kitna baki hai
Pls bro
If the value is 1 to 60 then 1, if value is 61 to 120 then 2, if value is 121 to 220 (for 100 numbers) then 3 and continue....4,5,6...
Then what is the if formula...?
Wow🎉🎉🎉🎉🎉
Iska formula excel me batao to janu apko master.
A1 = 10
A2 = 0
A3
A4
A5= (Condition applied)
My condition if A1>A2 then value in A5 is =A1 value as it is(=10).
दिपक जी नमस्कार, मैं नागपूर, महाराष्ट्र का रहिवासी हूं मूझे बताओ की एक्सेल शीट मे प्रेझेंट , अबसेंट और हाप डे वाले एम्प्लॉइज को कैसे ढूंडनआ उसके लिये फॉर्म्युला बताओ.
marksheet mei agar condition ho ke 2 subject mein passing marks se kam ho to compartment lika aaye ,
aur 3 ya isse jada wala fail to ye kaise hoga? pls reply.
Please provide link of the practice file in the description
Super'b
2 sheet mei agar 1 value jo sheet 1 mei Column A mei kahi bhi hai to True and nhi hai to false. chahe Sheet 1 ke cell A2 wali value Sheet 2 ke A31 cell mei hai to bhi true or poore A column mei nhi h to false. ye kaise banega formula
I am placing/writing a formula in cell C1
In A1 - Its EXPIRY DATE
In B1 - Its RENEWAL DATE
=IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT")
The above formula is working.
Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()
How to calculate 20% increase for broken year or period? For example 3minths, 7 months 11 months. In short less than one year period.
@Exceldelhiwala channel pe advance if formula hy..
80+ hours ka
You are pass
Bhai Mujhe time me lagana but logic hai in out print ho
Have u any online paid or free course... I want to basic to advance excel
"The specified formula cannot be entered because its uses more than 64 levels of nesting" ko resolve kr sakte h kya
I want share my excel with you...please share mail id
how put * sign in marksobtained of student less than 30 if marks is already fill up in the cill
Ms office 2013 pe kaam kre ga formula sir
Hanji karega
@@DeepakEduWorld thanks sir ❤️
Pdf kaha se mila
Sir , kya eise kuchh formula hai jise hum el number ki bich wala zero ko hata sakte hai .
Example - ek cell me hum 531096 likhe and formula laga hua cell me 53196 show ho .
Sir , कुछ ऐसा फार्मूला बताये , जिसे हम किसी नंबर की बीच वाला zero को हटा सके ।
Example - A1 सेल में हम 319056 लिखेंगे and B1 सेल में 31956 दिखाई दे ।
PLEAES RESOLVE BY IF FORMULA
ID DATE RESULT
1001 25-08-2024 1
1001 26-08-2024 2
1001 27-08-2024 3
1001 28-08-2024 4
1002 29-08-2024 1
1002 30-08-2024 2
1003 31-08-2024 1
1003 01-09-2024 2
1003 02-09-2024 3
PL SUGEST "IF" FORMULA FOR RESULT AS 3rd column
Sir ek question hai
Meri company me 10 employee hai jisme mene unko target diya hai agar vo 5 lakh se jyada sales karte hai to me unko 5 lakh pe 0.5% incentive duga or agar vo 10 lakh se jyada sales karte hai to me unhe 10 lakh ki amount pe 1% incentive duga to me use Excel me kese formula lagake pata karu ki kisko kitna incentive milega or muje 1 hi row line me jankari chahiye ???
Hii
दीपक सर मै आपसे निवेदन करत हॅू कि ( हिन्दी ) में एक Drop डाउन लिस्ट बना दीजिए । ईगलिश मे जो आप Drop डाउन लिस्ट का विडियो बनाकर अपलोड कियें थे सर जब वो Word Delate करते है सर Drop down list से भी हट जाता हैं । ये जानकारी मुझे अभी तक किसी भी यूटूब चैनल पर नही है । एक बार हिन्दी मे ड़ॉप डाउन लिस्ट बनाकर सही से explain कर दिजीए सर ।
G bilkul …. ✅
@@DeepakEduWorld thanks sir
Bhai kyu seekhe kya karege seekh ke batao aap seekhetae raho hum bhulte rahe hai..... Naukri to hai nahi
Aapko jarurat nahi or kisi ko to ho sakti hai
Tum bhulte isliye ho ki tumko Excel me interest he nhi hai. Aur Excel Sikh ke job he kyu karna. Excel teacher bano youtuber bano. Bahut option hai but tumko sikhna he nhi hai. tum study me politics mat ghusao nhi to tum ghus jaoge.
Itna badhiya samjhane Wale teacher tumko kabhi Mila bhi nhi hoga. Aur agar phir bhi samajh me na aaye to tumhare dimaag me gobar bhara hai. Beta tumse na ho payega.
@@satishthakur5451 acha competition kar le Bhai excel mein 😂 mere se pata chal jayega kisko excel Jada acha ata hai
@@nomadtales_11 yha competition karne ka bat nhi kar rha. Tere se Kam he janta hu lekin ek multinational company me working hu. Phir to tere se better he hu n main. Aur tu anab sanab bole ja rha hai comment me.
gvyjmnyxft
Thank you so much sir
Thank u so much sir
Thank you sir ji
th-cam.com/video/lvSyVqzABTM/w-d-xo.htmlsi=8khXtYGETKDyZ5Oo
Thank you so much sir