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

Mastering The IF Formula in Microsoft Excel (10 Examples) - IF Formula in excel | Excel IF Function
dosto is video me maine microsoft excel ke if formula ko 10 alag alag examples ke sath explain kiya hai agar apko if function use karna nahi aata hai ya hamesa if formula me confuse rahete ho ki ye excel formula and function use kahan kartey hain to ye video aapke liye hi hai dosto... ye video dekhne ke baad aap excel me masters ki tarh if formula lagana seekh jaoge #ifformula #iffunction #excel
in this excel tutorial i will show you, how to use if formula in excel with 10 different examples in hindi.
00:00 Intro
00:25 Basic Concepts of if formula (multiple examples)
05:09 Use Smiley in IF Formula
06:41 Extract Fail Student Names With Marks
08:35 Add Mr. Miss. in Names
10:07 Compare Two Values
10:49 Product Price Increment Using If Formula
11:59 Salary Increment Using If Formula
14:13 Hide Zero Returned By Sum Formula
15:15 Using IF AND
17:25 Grade Calculation Using If Formula
Download Training File : bit.ly/3XjnCBQ
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
if formula,if function,if function in excel,excel if function,excel if formula,excel if with and,microsoft excel,nested if formula,nested if function excel,if formula in excel,if function excel,

[@priyankakande2348]

Best tutor ... Providing practice file also.. Thank you so much sir.

[@umashankargupta401]

❤ Best Tutor on KZbin...

[@noorqadir8478]

Very informative especially if and formula. Thnx

[@factkichuski]

Ak baar me hi samajh me aa jaye kuch aisa tha experience 🙋 thanks keep teaching

[@Naseerkhankhel]

kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo

[@prasenjittalukdar9492]

Valuable information for me, thanks a lot,

[@rolexsir5957]

Wonderful Sir 👍❣️

[@vijaybhadrike7962]

One of the best channel on KZbin ❤

[@uptoten4367]

Video Bahu Achcha Laga Sir.

[@PuranKumarBhuwanta]

Deepak Sir, you are. awesome ❤❤

[@mdasgaransari295]

bahut hi beautiful videos

[@manojkulkarni6749]

सचमे बढिया विडिओ सर 👌👌

[@darshitchavda8264]

Awesome sirjee... It was nice feeling to watch your video

[@ankitsoni1519]

DEEPAK SIR YOUR TEACHING IS VERY GOOD

[@vindus4215]

Win +. For symbol, learned something new

[@gautamparmar2351]

Mast video 👌Aise or bhi formula ke videos banao sir

[@klrahul1304]

KZbin pr best chenal brother ❤

[@Naseerkhankhel]

kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo

[@smitar2587]

Thanks a lot,!!! Subscribed!!!

[@ramcharan-rm7ly]

Very good teaching brother

[@sureshram6907]

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

[@kawmalmustafa1537]

Thanks you sir.

[@factknowledgechannel661]

Nice video Plz upload subtotal video

[@kashtiarora4603]

❤loving your videos

[@rishabmittal5625]

Deepak bhai please ek series start karo jisme hum Ai ki help se excel use kare

[@syedejazhussain9753]

LOVE FOR YOU SIR YOU ARE KING OF EXCEL(I AM FROM PAK )

[@user-uq1dx3gm1j]

Thank you so much sir

[@sukhwindersingh747]

Thxx uhh sir 🙏

[@anaghapradhan7745]

U r best

[@exceltips305]

Very good video

[@adnanakram2217]

So good

[@mdasgaransari295]

lajawab videos

[@Naseerkhankhel]

kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo

[@curiousthoughts00]

thanks alot

[@pavansahani921]

Thank you sir ji

[@Naseerkhankhel]

kzbin.info/www/bejne/oqe2qomnr6Z1iq8si=8khXtYGETKDyZ5Oo

[@maheshseling9697]

very good. 👍️👍️👍️👍️🇳🇵🇳🇵🇳🇵

[@dattatraygurav1072]

nice video sirji ...apka koi excel ka advance paid course hai to bata dena ji...

[@azaan5alam56-qg3xk]

Wow🎉🎉🎉🎉🎉

[@subratamallik1264]

Super

[@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?

[@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

[@maheshkumarks6783]

Thanks

[@DeepakEduWorld]

🥰

[@rajugiri8221]

Sir aap say request hai yak bank statement ka PDF file ka yak video banaye jismi sumif, filter ka use karke bataye

[@anuragsharma2668]

deepak sir exel vba cheak box par video banaye

[@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.

[@raghavkumar5042]

Please provide link of the practice file in the description

[@satyaweddingfilms]

Hi brother Ek video banavo jisme Photographer booking, price, count automatically show kare kitna bookings huva, kitna payment aya kitna baki hai

[@satyaweddingfilms]

Pls bro

[@vijaypatel5269]

Super'b

[@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]

@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka

[@ashishmathiya1042]

Have u any online paid or free course... I want to basic to advance excel

[@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

[@nitintalhan8191]

दिपक जी नमस्कार, मैं नागपूर, महाराष्ट्र का रहिवासी हूं मूझे बताओ की एक्सेल शीट मे प्रेझेंट , अबसेंट और हाप डे वाले एम्प्लॉइज को कैसे ढूंडनआ उसके लिये फॉर्म्युला बताओ.

[@prajwalghimire5331]

how put * sign in marksobtained of student less than 30 if marks is already fill up in the cill

[@rajendrasinhdaya1745]

Ex 9 ka formula =if(min(c3:c5)>=40,"pass","fail")

[@navalsharma6246]

"The specified formula cannot be entered because its uses more than 64 levels of nesting" ko resolve kr sakte h kya

[@navalsharma6246]

I want share my excel with you...please share mail id

[@pardeepgahlot33]

Bhai Mujhe time me lagana but logic hai in out print ho

[@santoshkrishnan4624]

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()

[@harryjoshi2248]

You are pass

[@rambabubhai]

Ms office 2013 pe kaam kre ga formula sir

[@DeepakEduWorld]

Hanji karega

[@rambabubhai]

@@DeepakEduWorld thanks sir ❤️

[@Akhileshmajhi98]

दीपक सर मै आपसे निवेदन करत हॅू कि ( हिन्‍दी ) में ए‍क Drop डाउन लिस्‍ट बना दीजिए । ईगलिश मे जो आप Drop डाउन लिस्‍ट का विडियो बनाकर अपलोड कियें थे सर जब वो Word Delate करते है सर Drop down list से भी हट जाता हैं । ये जानकारी मुझे अभी तक किसी भी यूटूब चैनल पर नही है । एक बार हिन्दी मे ड़ॉप डाउन लिस्‍ट बनाकर सही से explain कर दिजीए सर ।

[@DeepakEduWorld]

G bilkul …. ✅

[@Akhileshmajhi98]

@@DeepakEduWorld thanks sir

[@DJBHUPESHROCKBAWAL]

gvyjmnyxft

[@TalkFlix_]

Bhai kyu seekhe kya karege seekh ke batao aap seekhetae raho hum bhulte rahe hai..... Naukri to hai nahi

[@Rkrajput9212]

Aapko jarurat nahi or kisi ko to ho sakti hai

[@satishthakur5451]

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]

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.

[@TalkFlix_]

@@satishthakur5451 acha competition kar le Bhai excel mein 😂 mere se pata chal jayega kisko excel Jada acha ata hai

[@satishthakur5451]

@@TalkFlix_ 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.

[@abhijitdorlikar9374]

Thank u so much sir