Excel's New Formula IFS & SWITCH versus the old IF Formula | Excel in Hindi

[@ashugoutam2683]

You are always great. Apki videos dekh kar hi apne dosto ko excel learn kara rha hu...

[@maheshsanghani6380]

GOOD WAY TO TEACH .

[@rajdevyadav7292]

Sir you're great...love and respect from me.....Jai Hind

[@iftekharraju318]

excellent.. Thanks

[@kuldeep.3012]

superb sir ji

[@yogitashadeeja947]

Best explanation

[@qasimsiddiqui9856]

brother you are genius

[@qasimsiddiqui9856]

Great 👌

[@raghibaslamkhan4012]

Nice formula

[@shaykh_dubai]

You solved my problem bro ... Thanks a lot ... Keep up the good work ... 👍👍👍

[@deepakchauhan6870]

Good One Sir..Keep it up..

[@ExcelSuperstar]

Thank you, I will

[@KamalKumar-wn4mn]

Superb

[@ExcelSuperstar]

Thanks 🤗

[@bikramsarkar2782]

Well thaught and learnt.

[@shijicsam6043]

Thanks rishab because of u I am a superstar in my company, colleagues are always seeking my help. Once again thanks

[@ExcelSuperstar]

Glad to hear that

[@VSREditing]

Super usefull formula Thanks for sharing

[@ExcelSuperstar]

Welcome 😊

[@Sabir__]

Great

[@gumnam9421]

Sir mail merge k bary mn bhi video bna dn plz

[@sanchitasinha9237]

Thank you helpful

[@ExcelSuperstar]

No problem

[@vakeelsingh4764]

sir ji .... stock maintain se related koi video baane...jisme 1 kit me bahut se item ho sirf kit minus karne item auto 2,2 ya 1,1 minus ho jaee...

[@abdulwaheed6333]

Sir kindly reply in professionally where we use this option as a accounts or store

[@m_faiz369]

Agar kisi work book me formula lga hua aur us cell me value 0 aaye to Row hide ho jay yadi 1 & above aaye to Row unhide ho jay aisa koi trik ya fir formula ho te hme pls btay Rishab Sir.

[@claytonmonserrate5447]

Can you make an video on how to replace multiple cells in one time

[@canirmalchoudhary8173]

Both formula are super duper powerful especially SWITCH formula which can be used sometimes instead of INDIRECT.

[@KoolCox]

Kaise?????

[@Sushantrana_1008]

Sir Practice Excel Sheet I'm Unable to Download. Please help

[@KamalKumar-wn4mn]

Dear sir plz guide us regarding formula to find first letter of vowel and first letter of consonent in ms excel 2007. For example: word "KAMAL" first letter of vowel is 'A' in kamal and first letter of consonent is 'K' in kamal...

[@farooqrpatel3802]

Use left and right function and then if function to match it with vowel

[@yourofficeguide8114]

Use function like this. It is an Example for checking vowels only =IF(IFERROR(SEARCH("a",M5),0)0,"A",IF(IFERROR(SEARCH("E",M5),0)0,"E",IF(IFERROR(SEARCH("I",M5),0)0,"I",IF(IFERROR(SEARCH("O",M5),0)0,"O",IF(IFERROR(SEARCH("U",M5),0)0,"U","no vowels found"))))) you can use some array formula which may result better.

[@yourofficeguide8114]

i have used search function because this is not case sensitive

[@Sachin-yj5uf]

Hi

[@naturefeels9521]

Thank you so much sir

[@ExcelSuperstar]

Most welcome