Mastering The IF Formula in Microsoft Excel (10 Examples) - IF Formula in excel | Excel IF Function

  Рет қаралды 124,869

Deepak EduWorld

Deepak EduWorld

Күн бұрын

Пікірлер
@maheshkumarks6783
@maheshkumarks6783 8 ай бұрын
Thanks
@DeepakEduWorld
@DeepakEduWorld 8 ай бұрын
🥰
@vijaybhadrike7962
@vijaybhadrike7962 Жыл бұрын
One of the best channel on KZbin ❤
@factkichuski
@factkichuski Жыл бұрын
Ak baar me hi samajh me aa jaye kuch aisa tha experience 🙋 thanks keep teaching
@Naseerkhankhel
@Naseerkhankhel 9 ай бұрын
kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo
@manojkulkarni6749
@manojkulkarni6749 Жыл бұрын
सचमे बढिया विडिओ सर 👌👌
@uptoten4367
@uptoten4367 Жыл бұрын
Video Bahu Achcha Laga Sir.
@noorqadir8478
@noorqadir8478 Жыл бұрын
Very informative especially if and formula. Thnx
@klrahul1304
@klrahul1304 Жыл бұрын
KZbin pr best chenal brother ❤
@Naseerkhankhel
@Naseerkhankhel 9 ай бұрын
kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo
@umashankargupta401
@umashankargupta401 Жыл бұрын
❤ Best Tutor on KZbin...
@ankitsoni1519
@ankitsoni1519 Жыл бұрын
DEEPAK SIR YOUR TEACHING IS VERY GOOD
@PuranKumarBhuwanta
@PuranKumarBhuwanta Жыл бұрын
Deepak Sir, you are. awesome ❤❤
@mdasgaransari295
@mdasgaransari295 Жыл бұрын
bahut hi beautiful videos
@ramcharan-rm7ly
@ramcharan-rm7ly 10 ай бұрын
Very good teaching brother
@vindus4215
@vindus4215 Жыл бұрын
Win +. For symbol, learned something new
@prasenjittalukdar9492
@prasenjittalukdar9492 Жыл бұрын
Valuable information for me, thanks a lot,
@rishabmittal5625
@rishabmittal5625 Жыл бұрын
Deepak bhai please ek series start karo jisme hum Ai ki help se excel use kare
@priyankakande2348
@priyankakande2348 6 ай бұрын
Best tutor ... Providing practice file also.. Thank you so much sir.
@rolexsir5957
@rolexsir5957 Жыл бұрын
Wonderful Sir 👍❣️
@kailashbhatia-h7e
@kailashbhatia-h7e 2 ай бұрын
thanks for sharing informative video
@gautamparmar2351
@gautamparmar2351 Жыл бұрын
Mast video 👌Aise or bhi formula ke videos banao sir
@factknowledgechannel661
@factknowledgechannel661 Жыл бұрын
Nice video Plz upload subtotal video
@pradyumnapothal138
@pradyumnapothal138 2 ай бұрын
Many thanks
@lazytick
@lazytick 3 ай бұрын
Pdf provided by yours is very very helpful and your teaching style is also ausm ❤
@RaunakPandey-vu5wf
@RaunakPandey-vu5wf 2 ай бұрын
Pdf kaha ha😢
@mr.bhupendra24
@mr.bhupendra24 Ай бұрын
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.
@alifawad1435
@alifawad1435 2 ай бұрын
Nice sir Thank you so much,
@syedejazhussain9753
@syedejazhussain9753 Жыл бұрын
LOVE FOR YOU SIR YOU ARE KING OF EXCEL(I AM FROM PAK )
@smitar2587
@smitar2587 9 ай бұрын
Thanks a lot,!!! Subscribed!!!
@darshitchavda8264
@darshitchavda8264 Жыл бұрын
Awesome sirjee... It was nice feeling to watch your video
@kashtiarora4603
@kashtiarora4603 Жыл бұрын
❤loving your videos
@gajubhaishah1926
@gajubhaishah1926 6 ай бұрын
You have good psce of teaching(explaining).Friendly to understand.Assents comfortable to understand ,Good going.My personal thanks👌👍
@RA-rh5lb
@RA-rh5lb 2 ай бұрын
Thank you so much, brother. Today I learned how to get smiley with press window and dot..
@DeepakEduWorld
@DeepakEduWorld 2 ай бұрын
Great 👍
@mannautomobiles1453
@mannautomobiles1453 5 ай бұрын
Thank You So Much
@sukhwindersingh747
@sukhwindersingh747 Жыл бұрын
Thxx uhh sir 🙏
@sureshram6907
@sureshram6907 10 ай бұрын
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
@iwill1389
@iwill1389 10 ай бұрын
@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka
@kawmalmustafa1537
@kawmalmustafa1537 Жыл бұрын
Thanks you sir.
@anaghapradhan7745
@anaghapradhan7745 Жыл бұрын
U r best
@RA-rh5lb
@RA-rh5lb 2 ай бұрын
I have a requirement where OR , AND need to be combined.. do you have any videos on ifs(and(OR)).. scenarios?
@bhawanimurariya8934
@bhawanimurariya8934 2 ай бұрын
Deepak Sir ek doubt hai If kaa use karke kya hum previous volume ko minus karte hue add on kar sakte hai
@mdasgaransari295
@mdasgaransari295 Жыл бұрын
lajawab videos
@Naseerkhankhel
@Naseerkhankhel 9 ай бұрын
kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo
@Eduvlog149
@Eduvlog149 2 ай бұрын
Deepak sir ek besic to advanced tally+Excel+ms word.
@prakashmishramishra8361
@prakashmishramishra8361 4 ай бұрын
Sir And wala Thora hard laga
@coolvideos9773
@coolvideos9773 2 ай бұрын
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!
@surajkumawat8364
@surajkumawat8364 9 күн бұрын
Sir mere pass 4 condition hai , agar koi value aaye to read and consumed ho jay, 0 ho to tempered ho jaye, kuch na ho to both locked ho jaye, please sir ye formula bataye
@dattatraygurav1072
@dattatraygurav1072 11 ай бұрын
nice video sirji ...apka koi excel ka advance paid course hai to bata dena ji...
@aqibfarooqfarooqahmaddar5265
@aqibfarooqfarooqahmaddar5265 13 күн бұрын
Superb
@aqibfarooqfarooqahmaddar5265
@aqibfarooqfarooqahmaddar5265 6 күн бұрын
Bring a marathon on acess
@maheshseling9697
@maheshseling9697 Жыл бұрын
very good. 👍️👍️👍️👍️🇳🇵🇳🇵🇳🇵
@exceltips305
@exceltips305 Жыл бұрын
Very good video
@rajugiri8221
@rajugiri8221 Жыл бұрын
Sir aap say request hai yak bank statement ka PDF file ka yak video banaye jismi sumif, filter ka use karke bataye
@maheshwaripankaj0203
@maheshwaripankaj0203 6 ай бұрын
for special paste use alt+ctrl+v
@Sangamerz1000
@Sangamerz1000 Жыл бұрын
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
@adnanakram2217
@adnanakram2217 Жыл бұрын
So good
@subratamallik1264
@subratamallik1264 Жыл бұрын
Super
@pradipkar9899
@pradipkar9899 Жыл бұрын
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?
@anuragsharma2668
@anuragsharma2668 Жыл бұрын
deepak sir exel vba cheak box par video banaye
@azaan5alam56-qg3xk
@azaan5alam56-qg3xk 9 ай бұрын
Wow🎉🎉🎉🎉🎉
@curiousthoughts00
@curiousthoughts00 7 ай бұрын
thanks alot
@satyaweddingfilms
@satyaweddingfilms Жыл бұрын
Hi brother Ek video banavo jisme Photographer booking, price, count automatically show kare kitna bookings huva, kitna payment aya kitna baki hai
@satyaweddingfilms
@satyaweddingfilms Жыл бұрын
Pls bro
@raghavkumar5042
@raghavkumar5042 Жыл бұрын
Please provide link of the practice file in the description
@mr.bhupendra24
@mr.bhupendra24 Ай бұрын
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).
@Meriapeksha
@Meriapeksha 6 ай бұрын
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
@rajendrasinhdaya1745
@rajendrasinhdaya1745 10 ай бұрын
Ex 9 ka formula =if(min(c3:c5)>=40,"pass","fail")
@souravsingh4027
@souravsingh4027 Жыл бұрын
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.
@dvaibhav1
@dvaibhav1 5 ай бұрын
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...?
@nitintalhan8191
@nitintalhan8191 11 ай бұрын
दिपक जी नमस्कार, मैं नागपूर, महाराष्ट्र का रहिवासी हूं मूझे बताओ की एक्सेल शीट मे प्रेझेंट , अबसेंट और हाप डे वाले एम्प्लॉइज को कैसे ढूंडनआ उसके लिये फॉर्म्युला बताओ.
@ashishmathiya1042
@ashishmathiya1042 Жыл бұрын
Have u any online paid or free course... I want to basic to advance excel
@navalsharma6246
@navalsharma6246 Жыл бұрын
"The specified formula cannot be entered because its uses more than 64 levels of nesting" ko resolve kr sakte h kya
@navalsharma6246
@navalsharma6246 Жыл бұрын
I want share my excel with you...please share mail id
@rambabubhai
@rambabubhai Жыл бұрын
Ms office 2013 pe kaam kre ga formula sir
@DeepakEduWorld
@DeepakEduWorld Жыл бұрын
Hanji karega
@rambabubhai
@rambabubhai Жыл бұрын
@@DeepakEduWorld thanks sir ❤️
@sanjibmohapatra4153
@sanjibmohapatra4153 6 ай бұрын
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 .
@sanjibmohapatra4153
@sanjibmohapatra4153 6 ай бұрын
Sir , कुछ ऐसा फार्मूला बताये , जिसे हम किसी नंबर की बीच वाला zero को हटा सके । Example - A1 सेल में हम 319056 लिखेंगे and B1 सेल में 31956 दिखाई दे ।
@rahuladvisor
@rahuladvisor Жыл бұрын
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
@singhsujit642singh2
@singhsujit642singh2 18 сағат бұрын
can iget this excel sheet
@santoshkrishnan4624
@santoshkrishnan4624 7 ай бұрын
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()
@zahidbadshahrzi3930
@zahidbadshahrzi3930 Жыл бұрын
How to calculate 20% increase for broken year or period? For example 3minths, 7 months 11 months. In short less than one year period.
@iwill1389
@iwill1389 10 ай бұрын
@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka
@prajwalghimire5331
@prajwalghimire5331 Жыл бұрын
how put * sign in marksobtained of student less than 30 if marks is already fill up in the cill
@pardeepgahlot33
@pardeepgahlot33 10 ай бұрын
Bhai Mujhe time me lagana but logic hai in out print ho
@anandparmar1621
@anandparmar1621 5 ай бұрын
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 ???
@AnitaYadav-ps2up
@AnitaYadav-ps2up 2 ай бұрын
Hii
@RaunakPandey-vu5wf
@RaunakPandey-vu5wf 2 ай бұрын
Pdf kaha se mila
@AkhileshStudioB
@AkhileshStudioB Жыл бұрын
दीपक सर मै आपसे निवेदन करत हॅू कि ( हिन्‍दी ) में ए‍क Drop डाउन लिस्‍ट बना दीजिए । ईगलिश मे जो आप Drop डाउन लिस्‍ट का विडियो बनाकर अपलोड कियें थे सर जब वो Word Delate करते है सर Drop down list से भी हट जाता हैं । ये जानकारी मुझे अभी तक किसी भी यूटूब चैनल पर नही है । एक बार हिन्दी मे ड़ॉप डाउन लिस्‍ट बनाकर सही से explain कर दिजीए सर ।
@DeepakEduWorld
@DeepakEduWorld Жыл бұрын
G bilkul …. ✅
@AkhileshStudioB
@AkhileshStudioB Жыл бұрын
@@DeepakEduWorld thanks sir
@vijaypatel5269
@vijaypatel5269 Жыл бұрын
Super'b
@harryjoshi2248
@harryjoshi2248 9 ай бұрын
You are pass
@arkucr.arkucr
@arkucr.arkucr 3 ай бұрын
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
@nomadtales_11
@nomadtales_11 Жыл бұрын
Bhai kyu seekhe kya karege seekh ke batao aap seekhetae raho hum bhulte rahe hai..... Naukri to hai nahi
@Rkrajput9212
@Rkrajput9212 Жыл бұрын
Aapko jarurat nahi or kisi ko to ho sakti hai
@satishthakur5451
@satishthakur5451 11 ай бұрын
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.
@satishthakur5451
@satishthakur5451 11 ай бұрын
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
@nomadtales_11 11 ай бұрын
@@satishthakur5451 acha competition kar le Bhai excel mein 😂 mere se pata chal jayega kisko excel Jada acha ata hai
@satishthakur5451
@satishthakur5451 11 ай бұрын
@@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.
@DJBHUPESHROCKBAWAL
@DJBHUPESHROCKBAWAL 6 ай бұрын
gvyjmnyxft
@ChandanBenche
@ChandanBenche Жыл бұрын
Thank you so much sir
@abhijitdorlikar9374
@abhijitdorlikar9374 Жыл бұрын
Thank u so much sir
@pavansahani921
@pavansahani921 Жыл бұрын
Thank you sir ji
@Naseerkhankhel
@Naseerkhankhel 9 ай бұрын
kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo
@KRibadiya
@KRibadiya 5 ай бұрын
Thank you so much sir
«Жат бауыр» телехикаясы І 26-бөлім
52:18
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 434 М.
Vampire SUCKS Human Energy 🧛🏻‍♂️🪫 (ft. @StevenHe )
0:34
Alan Chikin Chow
Рет қаралды 138 МЛН
What Xlookup Can Do For You ? Xlookup Tutorial - Xlookup in Excel in Hindi
29:23
12 Most Useful Excel Formulas and Functions | Excel Formulas in Hindi
46:45
Why Excel Power Pivot is a Game-Changer for Data Analysis🔥
17:12
Satish Dhawale
Рет қаралды 130 М.
«Жат бауыр» телехикаясы І 26-бөлім
52:18
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 434 М.