Say Goodbye to IF Formula in Excel with SWITCH Formula | Excel user must Know

🙏- Join Pandrive Course - offline.pcskil...
Say Goodbye to IF Formula in Excel with SWITCH Formula | Excel user must Know Aaj ke video mein hum aapko batayenge kaise aap Excel mein IF formula ki jagah SWITCH formula ka istemal karke apne tasks ko aur bhi efficiently manage kar sakte hain! Ji haan, aapne sahi suna, ab aapko kisi bhi complex conditions ko handle karne ke liye IF formula ki jagah SWITCH formula ka istemal karna hai.
*Video Ke Khaas Points:*
1. *SWITCH Formula Introduction:* Hum shuruwat karenge SWITCH formula ke introduction se aur yeh kya hai aur kaise kaam karta hai.
2. *Comparison with IF Formula:* Aapko dikhayenge kaise SWITCH formula IF formula se alag hai aur kaise aapko iska istemal karke apne Excel sheets ko aur bhi efficiently manage kar sakte hain.
3. *Syntax and Examples:* Hum aapko denge SWITCH formula ke syntax aur kuch practical examples jisse aapko samajh aaye ki kaise aap iska istemal kar sakte hain.
4. *Use Cases:* Aap dekhege kuch real-life scenarios jahan SWITCH formula ka istemal karke aap apne tasks ko aur bhi efficiently handle kar sakte hain.
5. *Tips and Tricks:* Hum aapko denge kuch tips and tricks jisse aap SWITCH formula ka istemal karke aur bhi proficient ban sakein.
Toh dosto, agar aap bhi chahte hain apne Excel skills ko aur bhi enhance karna, toh yeh video aapke liye hai. Video dekhiye, sikhiye, aur humare saath apne thoughts share kijiye.
Our Other useful KZbin channel please subscribe
1 - Abhimanyu Bhardwaj - bit.ly/32hGhQK
2 - My Big Guide - bit.ly/3gvRTtq
3 - My Mobile Guide - bit.ly/3gurBIe
4 - My Computer Course - bit.ly/3xpX8R6
5 - Graphic Gyan - bit.ly/3vsSz7n
6 - Only Excel - bit.ly/2SwHxAB
7- CCC Guide - bit.ly/3gzdEJa
8 - PC Skill - bit.ly/35ttVbZ
9 - My Buying Guide - bit.ly/3f3ENR1
Our Top Video Playlists in Hindi -
All Videos Of Learn tally in Hindi - bit.ly/2MC9oLa
All videos of Excel in Hindi - goo.gl/aF43Hs
All videos of access to Hindi - goo.gl/LRohxH
All videos of MS Word in Hindi - goo.gl/1yKpk1
All video of computer networking in Hindi - goo.gl/9qmhvL
All videos of Photoshop in Hindi - goo.gl/AVsjLZ
All videos of Windows 7 in Hindi - goo.gl/z44h2d
All videos of Gmail Tips in Hindi - goo.gl/h3EZzv
All videos of KZbin Tips in Hindi - goo.gl/zqzoJW
All the videos of technology in Hindi - goo.gl/pfQKsk
Facebook - / geekyabhimanyu
Websites - mybigguide.com
Like us on Facebook : / mybigguide
Follow us on Google+ : plus.google.co...
Follow us on Twitter : / mybigguide
Android app on Play store : goo.gl/pNJWTv
We always provide useful content on the My Big Guide channel, here MS Excel tips and tricks, and tips and tricks for MS Word, and Internet tips and tricks, along with the computer related Useful Information Simple language available in Hindi You can visit our website for more information.
It is our effort to get this information useful for all types of Excel users, computer users and internet users.

[@manjariyauday254]

Good evening sir, बिजली का बिल बनाने में 1- 50 , 51 - 150, 151 - 300 यूनिट का अलग अलग रेट लगाना हो और उसीके साथ फिक्स चार्ज भी अलग अलग लगाना है,कैसे करे please sir

[@Laxman71506]

Isi topic ke upar video banavo please

[@HimanshuMishra-b1s]

Ifs try kero

[@akankshatrivedi1513]

Kesco se ho bhai lag raha.

[@Happy-B001]

Sir swich wale formula se division bhi nikal sakte hai kya

[@Amazingshorts8011]

Useful video thankyou ✌️

[@shantilalrajput8708]

V.Useful Sir Thank You Sir 🇮🇳🇮🇳🇮🇳

[@civilengineeringpower]

Always Content no.1

[@sirajulhaquechoudhury8519]

Sir, your teaching is easy to learn. Pl. give income tax formula for marginal relief under the new tax regime. It will be very helpful to calculate tax rebate under section 87a.😅

[@roliawasti4300]

Thanx for the video, but some of the formulas you are suggesting are not shown in our Excel, please help us by explaining this. How the said switch formula will be shown in our excel to try the examples

[@yoyogamming916]

Love you sir thanks

[@understandthewordsfeelthes3036]

Helpful information 👍👌

[@vickybhawsar7405]

Kya isme vlookup bhi use kar sakte hai kya?

[@rshah4672]

Ha

[@hussinali8858]

Hi, how to create a formulae, eg: if in Column A1 is 1, therefore the Answer shall be the same as shown in it.

[@SubhamSharma-iu7ub]

Thank you

[@deepikasahu1667]

Sirji Pdf table wali file ko excel m export karke unko kaise editing kr sakte h? 👏

[@jaynarayanpradhan8969]

Abhimanyu ji , Excel me do cells ke minimum value ka sum kaise kare

[@magicofoldsong]

Sir Blender Software Ka Full Tutorial Banaye PLZ Reply Kab Banayege namaste 🙏

[@mr.bhupendra24]

Excel me THEN formula ka use kaise karte hai, bataye sir.

[@zamanshaikh5971]

Agar deffent valu ki excellent shet ho to usko alag count karne ke bjaye atumetic kaise count kren ki is cell men code 1 total kitna hai code 2 kitna hI

[@Bhogayta143]

V lookup ki help se bhi kar sakte mene dekha tha lekin yad nahi aa raha Sir plz aap us par bhi ek video banaye Me private school me job karta hu waha Result banane me grade me ye use hota he Tab me if ka use karta hu

[@LOKESHBANSAL-w7j]

Sir mobile se booklet kaise banaye for hp m1005

[@remgurung2019]

pendrive course abroad walo ke liye kya option hai sir??

[@rahulkumar-9570]

Good formula

[@mybigguidehindi]

Thanks 🙏

[@SunnySingh-sz7uj]

Sir Bina copy paste, bina print area ka use kiye print kaise nikale

[@chandrakamalpaswan948]

Crypto currency par course banaeye Please

[@mohannegi6096]

THANX bt jb hm conditions dete jese ki >=45 to c, >=60 B etc to fir SWITCH Formule result nhi de pe rha ya hm farmula glt aply kr rhe ?

[@shalikbk6877]

Sir,Namaskar, 2 condition in 1value ,2 condition in 1value 4 time how to apply formula

[@DeepakKumarMachhua]

Specific column k liye kya kare

[@BrijvirSingh-l3e]

Nice

[@VideoAtoZ2024]

Namaste Sir, सर दो तीन दिन पहले आप का एक विडियो देखा उसमें कन्ट्रोल ई का प्रयोग बताए थे मैं चेक किया था काम नहीं करता है

[@tumitshriwas]

agr google sheet s download kiya gaya data filterd h humne serial no v 1 s feel kar diya ab is data m curection ho gaya h color lag gaya h ab vapas google sheet m usi jgh data feel krna h kese kre sir

[@dollyshah2764]

This is for fixed results....how to set Sw formula for 'more than equal to' ya 'less than equal to'....marks

[@LaxmiTelecom-b3b]

Switch Formula not shown in my formula bar, please help me as soon as possible.

[@tarasharma3555]

Sir short key krwa dijiye

[@PrernaSutra108]

Mai criticise nahi kar rha hun mere according Vlookup bhi lag skta tha....

[@ranjeetshakya7075]

लेकिन अगर ग्रेड 10-10 के ग्रुप में निकालना हो तो क्या करें? तब स्विच कैसे लगाएं?

[@fastdigitallife4083]

Hi sir mere excel 365 ma ek problem ha ki jab be ma kise file ma Kam karta hu with formula and table krate kr close kr data hu file reopen pr sabi formula wrong ho jate ha ese thek kase kare

[@pulkitgupta1612]

Agar value ki jagah formula lgana ho to kese hoga ? =IF(F2="POLYBAG","=W*L*thickness/3300")

[@mr.bhupendra24]

C8=other cell C7 value THEN =0 C8 is not=other cell value THEN C8 value is dedicated from Next cell C9 value. define kijiye kaise hoga

[@parveenbhardwaj7985]

is forumula m error aa rhe h

[@satishcomputersportsedu.9440]

माइंड ब्लोइंग sir

[@mybigguidehindi]

🙏- Join Pandrive Course - offline.pcskill.in/

[@skmanagementserv]

bhai mere jhan aap bar bar if laga rahe ho whan par IFS wala formula bhi to use ho sakta he na, ap bhi long formula wala example de rahe ho kyon, IFS wala kyon nhi use kiya apne, ya apko iske bare me pata nhihe

[@skmanagementserv]

jo kaam switch formula kar raha he vo same kaam IFS formula bhi karna he, do you understand

[@SurendraSingh-ru9nq]

Sir Date of birth me year kese add kr sakte h formula se jisse retirement date aa jaye Jese 06.05.1984 +60= retirement date mil jaye

[@rajtalk3766]

=Date(Year(A1)+60,month(A1),day(A1)) Ye lga dena formula...year me hi add krna ha esliye year me 60 add kiya hai....mene Cell A1 ke according formula bnaya hai ok

[@SurendraSingh-ru9nq]

@@rajtalk3766 Thanks for reply month ki last date bhi aa jayegi ? Qki retirement month ki last date ko hota h

[@rajtalk3766]

@@SurendraSingh-ru9nq sab aa jaega...

[@SurendraSingh-ru9nq]

@@rajtalk3766 Thanks

[@SurendraSingh-ru9nq]

Month ki last date nhi aa rhi Jese 6 May h to 31 May aana chahiye lekin 6 May hi aa rha h Year add ho rha h sir

[@ravindramaithil9917]

सर Excel में 90 कुंतल 45 किलो 500 ग्राम (90.45.500) लिख जाए दशमलव के साथ और टोटल भी हो जाए कोई फॉर्मूला है तो बताएं

[@WindowsGuides]

9045.500. Qtl

[@ravindramaithil9917]

@@WindowsGuides 90.45.500 इस प्रकार से बताओ

[@parveenbhardwaj7985]

switch likh raha hu to formula show nhi ho raha h

[@tayalcreations436]

Not working