If Formula in Excel with Multiple Conditions | Excel IF Function | Excel Tutorial

[@MDataFinnovatics]

Call us at [phone] for Advanced Excel LIVE Training, Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍

[@debolinadewanghosh4236]

How much it cost? i am interested

[@kashifqasim8069]

Well explained

[@MDataFinnovatics]

Thanks Kashif!

[@soniashafi9682]

JazakAllah sir tomorrow I have my IT business paper, it really helped me JazakAllah

[@MDataFinnovatics]

Hi soniashafi9682 , I am really happy that our videos are helping you in your paper. Thanks for watching our videos!

[@manojchaursia6501]

Nice video sir ji

[@MDataFinnovatics]

Thank you Manoj Chaursia!

[@muraligopal801]

Very clear explanation thanks for sharing

[@MDataFinnovatics]

Glad it was helpful!

[@soumya_adamyavlogs]

Very helpful

[@MDataFinnovatics]

Thank you Adamya!

[@sachinjagalekar7288]

excellent boss

[@MDataFinnovatics]

Thank you Sachin..

[@SanjaySingh-su4rn]

आपका समझाने का तरीका बहुत सुंदर है

[@MDataFinnovatics]

Thank Sanjay ji!

[@manavcaculo2976]

solved my problem in a minute, thank you!!

[@MDataFinnovatics]

You're welcome Manav Caculo!

[@BPK2]

Thank u very much for the commission formula I saw 10 videos they just said only about met not met pass fail etc only alphabets But numbers That is commission u daud Thank u it helped me calculate income tax

[@MDataFinnovatics]

Happy to hear that you liked the video!! Don't forget to link, share and subscribe to the channel for this kind of interesting and knowledgeable video. 🙂

[@Gamingvibesop]

EXCELLENT WITH DEPTH

[@krishnakumarnayak1378]

i have been trying to do condition 3 from a month or more today i got got the clue of the same . THANK U SO MUCH SIR🤗🤗😀😀😀💯💯

[@MDataFinnovatics]

That's really great! Thank you for watching the videos and your support!!

[@sudeernarayan5411]

Well explained, thanks a lot sir🙏

[@suklasukla2468]

Thnkeu so much sir🎉🎉

[@MDataFinnovatics]

Thank you!

[@debolinadewanghosh4236]

excellent

[@MDataFinnovatics]

Thank you Debolinadewanghosh!

[@prashant984]

Very nicely elaborated thanks it's worthy

[@MDataFinnovatics]

Thank you, Prashant Mishra.

[@nirajborkar7817]

Excellent sir. Nice discription, very important

[@MDataFinnovatics]

Thank you Niraj Borkar!

[@shubhamarote4685]

Really good teaching 😊

[@MDataFinnovatics]

Thank you Shubham!

[@DelhiKPahadi]

Simple and greAt explain

[@MDataFinnovatics]

Thanks Suraj Bisht!!

[@bakervai7658]

Thanku sir 👍👍👍👍

[@MDataFinnovatics]

Your Welcome Baker Vai!!

[@lavanya1758]

perfect and excellent your video👌

[@MDataFinnovatics]

Thank you Lavanya!!

[@varshasingh-dp9zs]

Hello, your way of teaching is superb sir n how you explain the concept, it will really help me a lot Thank you so much 👍👍👍👍👍

[@MDataFinnovatics]

Varsha, thank you for your comments. Don't forget to subscribe and share the videos with your friends!

[@cutoworld7425]

New learning from your Video sir. Thank you.

[@MDataFinnovatics]

Thank you!

[@charansalve2622]

Thank you for good knowledge!

[@MDataFinnovatics]

Your welcome, Charan Salve. Don't forget to share and subscribe the channel!!

[@shahzstudio3889]

Excellent video

[@MDataFinnovatics]

Thank you very much Shahz!

[@shobzkhan2850]

Very nice.. Keep up the good work

[@MDataFinnovatics]

Thank you shobz!

[@murarikumar165]

great video with excellent explanation

[@MDataFinnovatics]

Thank you for your support!

[@rohitjadhav1527]

Awesome Sir..thank you :)

[@MDataFinnovatics]

Your welcome Rohit Jadhav!!

[@ajaychoubey368]

Sir offset ke upar bhi ek video bana do

[@MDataFinnovatics]

Okay. We will create a video on offset very soon!!

[@AbdulRasheed-qx3iq]

Well done sir.

[@MDataFinnovatics]

Thank you Abdul!

[@myknowledgeeducation.1745]

Helpful for me..thanks 👍

[@MDataFinnovatics]

Your Welcome MS creater!!

[@narendersapra1685]

Gr8 learnings for all

[@MDataFinnovatics]

Thank you Sir...

[@rachanacharan1411]

Excellent sir .. thank you so much

[@MDataFinnovatics]

Thank you Rachana Charan for liking the videos!

[@JAVEDZULFIQAR]

thanks man, i learned condition 3 and it will help me alot

[@MDataFinnovatics]

Glad to hear that! I believe you will learn more advanced conditions from this video also - kzbin.info/www/bejne/jILammpjnrekgs0 . Don't forget to like, share and subscribe. 🙂

[@laveshghadi2200]

Thanks a lot sir

[@MDataFinnovatics]

Thank you Lavesh Ghadi!

[@dipakpapu]

Great👍

[@Isaiah9.6]

Superb! Just wow!

[@MDataFinnovatics]

Thanks a lot Leena!

[@abhaychauhan253]

Thankyou so much 😊

[@MDataFinnovatics]

Abhay, your welcome. 😊

[@ripondey3738]

good work,if+vlookup was good

[@MDataFinnovatics]

Thank you Ripon Dey!!! I believe you will like the below videos on IF formula also: IF - AND - OR : kzbin.info/www/bejne/jILammpjnrekgs0 Nested IF + AND : kzbin.info/www/bejne/hJiWo5aJgLyJaqc IF Formula + Other Formulas : kzbin.info/www/bejne/maWXmGOBrMyteqM

[@naturefeels9521]

Cool vedio sir or bnayeyaii 👍

[@MDataFinnovatics]

Thanks and sure

[@shriyasejpal661]

Thanks, this helped!

[@prafulnakhate7713]

Dear Sir, I am working in a pesticide company and have bulk data to calculate monthly working on Cash Discounts with respect to payments collected in day-wise credit notes. Hence, if possible make one video on the same.

[@MDataFinnovatics]

Praful, if possible, please share your sample data at [e-mail] with your challenges. We will try to create a video on the same accordingly!

[@ajaychoubey368]

Very helpful sir 😊

[@MDataFinnovatics]

Thank you!

[@VeSecret]

Very well explained 👍

[@MDataFinnovatics]

Thank you 🙂

[@AMITJAIN-vo7tm]

Hello sir can u plz make a video of making marksheet or grade sheet of a school or college. I will provide the field required to create marksheet.

[@MDataFinnovatics]

Sure Amit. Please share your data and requirement. We will try to create a video on the same.

[@AMITJAIN-vo7tm]

@@MDataFinnovatics ok sir i will share a marksheet for this.

[@AMITJAIN-vo7tm]

@@MDataFinnovatics sir i had mailed you a query regarding sum function Kindly look in that regards

[@PuranKumarBhuwanta]

Excellent Sir...

[@umakanta1984]

can you help please on multiple rows repaet value and another column some critical data

[@MDataFinnovatics]

Hi Umakanta, Could you provide some examples so we can create a video accordingly?

[@nidhiverma9656]

Superb

[@nageshkaushik315]

Wow sir good initiate mujhe bhi sikhna h

[@MDataFinnovatics]

Thanks...

[@yagnaganeshkumar5455]

Super Sir

[@MDataFinnovatics]

Thanks!!

[@surajitroy6752]

Nice and helping Video

[@MDataFinnovatics]

Thanks. Subscribe the channel for more interesting videos. Don't forgot to share with your family and friends. 🙂

[@LeadYouLife]

Explained very well Thanks

[@MDataFinnovatics]

Thank you!

[@forimax9642]

amazing video sir , I have a sheet can you please make a video on it I can mail you and please explain to us..that will be very helpfull..

[@MDataFinnovatics]

Imax, please share your file via email. If we think that your query will be beneficial for multiple users, then we will definitely make a video on that!

[@priyankahaware9256]

Best video

[@MDataFinnovatics]

Thank you Priyanka!!

[@dkboss5439]

❤️❤️ great

[@MDataFinnovatics]

Thank you Dk Boss!

[@ammudeba]

Very interesting video sir, my question is how can we use the item Name and it's rate from a different worksheet by using item code by typing item code manually.

[@MDataFinnovatics]

MAAMIR, you can simply use VLOOKUP formula!

[@yagnaganeshkumar5455]

Sir one employee half day present and half day absent then how to calculate the employee attendance sheet formula sir

[@MDataFinnovatics]

Hi Yagna, I didn't get your query. Please share your query with the excel file so that we can give you the proper solution.

[@AbdulRasheed-qx3iq]

Sir tell me we can add product coloum in main data.

[@MDataFinnovatics]

Abdul, You can add any column in the data. This is the beauty of excel.

[@ubaidillahmuhammad20]

Nice and good job. Put excel practiced files in the description.

[@MDataFinnovatics]

Thanks. We have shared the link in the description. Please check. You can download the files directly from this link - www.mdatafinnovatics.com/KZbinVideoAttachments/

[@ishfaqmuhammad822]

truly worthy, excellent work

[@MDataFinnovatics]

Thank you!

[@VinodKumar-zw1bj]

Good morning sir, ek sheet m stock hai mujhe use other sheet per ik range m stock qty. Chaiye example 1st column 0, 2nd 1-5, 3rd 6-100 kay ye posible hai sir please help

[@MDataFinnovatics]

Vinod Ji, please share your excel data first, and only then we will be able to advise you. You can send us an excel file with all of the details to [e-mail].

[@shivambisht5952]

Sir will u plz make this data available to us

[@MDataFinnovatics]

You can download the file from here - docs.google.com/spreadsheets/d/1pOkYiAJUjh5CvDG0UHpQg4KkFjAIQSAA/edit?usp=sharing&ouid=112506439037339224674&rtpof=true&sd=true

[@Amazing_India_Journey]

Very nice

[@MDataFinnovatics]

Thanks Harish Pardhan!

[@raunakmukherjee5468]

I need a help. I have an attendance sheet which contains P, W, A, H in list P should indicate Present W -- weekly Off A -- Absent H -- Half Day How should I make that formulae

[@MDataFinnovatics]

You can use =IF(A1="P","Present",IF(A1="W","Weekly Off",IF(A1="A","Absent",IF(A1="H","Half Day","")))) formula for your above query. You can use vlookup formula also.

[@dilshadahmed5918]

Repeat value per vlookup with condition

[@mishrafamily2224]

Ek data hai, hamare pass fixed vehicle hai 12 ghante ke liye or yadi wah 12 ghante se jyada chalta hai to agle 12 gahnte k lie OT hoga, fir uske agle 12 ghante fix hoga is tarah se o gadi chali hai 400 ghante to isme kaise apply hoga formula? Need help i am stuck from last two days.

[@MDataFinnovatics]

Mishra Family, iske liye aap ek table create karlo jisme jitne bhi scenarios hai wo mention karlo like 0 to 12 ghante ke liye ye hoga, 13 to 24 hours ke liye ye hoga and so on. And then is table se aap vlookup laga lena.

[@OptionTraderz]

Can You Please Make a Video If Met Cell colour Green and If Not Met Cell Colour Become Red

[@MDataFinnovatics]

Sir, You can color your data the way you want by using conditional formatting, which we have already presented in a video. But, we will try to create a another video to color the data by Green and Red color.

[@OptionTraderz]

@@MDataFinnovatics Ok Thanks

[@MDataFinnovatics]

Sir, you will soon see a video showing how to use Excel in the stock market for analysis. So, stay tuned and subscribe the channel for more knowledgeable videos. 👍

[@OptionTraderz]

@@MDataFinnovatics Exactly You Commented What I Wanted Actully I Made One Excel Sheet and Pull Data Directly From NSE , i Want if PCR Ratio is More Than 1 to 1.2 No Trade , Between 1.2 to 1.4 Buy , Below 1 Sell Buy Colour Green , Sell Colour Red , No Trade Colour Orange , Please Share Your WhatsApp Number ..... I Have Knowledge Of Share Market , We Both Can Earn Lots Of Money Using Our Mind

[@OptionTraderz]

@@MDataFinnovatics Today Date Knowledge is Power .... Just need Work Togather to Earn Money

[@Gamingvibesop]

YOU TOLD HOW A FORMULA IS FORMING WHICH MOST VIDEO DONT TELL LIKE YOURS. PLEASE also MAKE VIDEO ON WHY AND WHEN WE USE "" +1 _1 ? * , comma etc. and many more AND WHAT IS THEIR MEANING IN THE FORMULA. please definitely make one

[@ajayparashar8603]

Mujhe income tax slab fy 2024 2025 if and o formula kaise kare।

[@mohamedelbaz8667]

Hello , Can we make a one equation for multi conditions like the following :- - if someone have data within a couple of months (date of visit - weight- a score) we need to find out if he acheived this score or no within 30 days OR if his weight decreased by a specific percentage within 30 days

[@MDataFinnovatics]

Yes, you can apply multiple conditions in the formula. I think as per your requirement you can use IF formula with AND & OR formulas. Watch this video - kzbin.info/www/bejne/jILammpjnrekgs0. I hope you will get your answer. If not, then you can share your query with the excel file with us.

[@amar8770]

Sir एक ऐसा फार्मूला बताए , जिसमे की कोई भी date लिखे तो वह date अपने next, wednesday या saturday की date में convert हो जाए

[@MDataFinnovatics]

Hi Amar, There is no specific formula as per your requirement but you can customize the formulas. You can use "=A1+(7-WEEKDAY(A1)+4)" formula to get the next Wednesday where A1 is the cell which contains the date. In the same way you can customize for Saturday also. Please do subscribe the channel and share the videos if you like!

[@amar8770]

@@MDataFinnovatics जी sir

[@MDataFinnovatics]

Watch the updated video on how to calculate the next Wednesday. kzbin.info/www/bejne/Zp6Qp3ebmN93jJo

[@RajKumar-di4jo]

Dear sir, thanks for tutorial but you have uploaded wrong file.... please check

[@MDataFinnovatics]

Dear Raj, thanks for checking. The file link is correct, go to that particular link and at the bottom of the page you will find the file link.

[@vakeelsingh4764]

SIR..... A-Z TAK KOI ITEM HAI..MAI 1 MINUS KARU TO A-H 1 MINUS HO,H-Z TAK 2 MINUS HO.... YE KESE HOGA?

[@MDataFinnovatics]

Hi Vakeel, You can take a reference of Column numbers instead of A to Z text values. For example you can use Column number 1 to 8 for A to H column and 9 to 26 for I to Z column. Use "=COLUMN()" formula.

[@ACHARYARAMESHSACHDEVA]

I Want online help for using, if condition In a chart I have villages in column "A" I have Class in Coloumn "B" I have van fee rates in column "C" Not I want to use it as there are approx 30 villages and van fee is differ for class 6-8 and 9-12 in the village

[@MDataFinnovatics]

Please share your excel file and detailed requirement at [e-mail] along with your contact number.

[@mikewashington4188]

I cannot access the page to get the file.

[@MDataFinnovatics]

Please refresh the page and try again the file is still there. If still you are not able to get the file then share your email address we will send an email to you!

[@amarrraochauvan4113]

Bro your video is blurr we are unable to see. Nothing is visible

[@MDataFinnovatics]

Please watch the video in high definition, bro. Your suggestions will be taken into consideration when we produce future videos. Thank you!

[@WaqasHPasha-pj4ry]

Can we use "if" & "and" nestex function in condition 3?

[@MDataFinnovatics]

There is no need of AND formula. AND we use when we have more than 1 condition at a time. So, here you can simply use Nested IF which means Multiple If formulas.

[@Taks_1985]

Respected Sir, I am working in Postal Department, I Have a data based on which I have to calculate commission to employees, Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission.. I will be very Grateful 🙏 I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel... Please

[@MDataFinnovatics]

Piyush, Please share your requirement, data and contact number at [e-mail]. The team will contact and assist you accordingly.

[@goergejohn6986]

Thanks, what if for Condition 3 there are additional conditions? for example there is another similar to the 10k to 15k condition?

[@MDataFinnovatics]

You have to use Nested IF(Multiple Ifs) if you have multiple conditions.

[@MukeshSoni-et7qr]

sir ek hi cell me =if(E12=G10,''G10'') dono fromula kese use kare

[@MDataFinnovatics]

Always remember that if you have condition from single column then you can directly us IF formula. But if you have conditions from multiple columns then we need to use AND, OR formulas also. Watch this video - kzbin.info/www/bejne/jILammpjnrekgs0 to get more clarity how to use both formulas together as per your query.

[@deepakbisht5938]

Sir if I have to give HRA according to the level of the employee and there are 8 level in my office I have to use IF formula 7 time same as condition 3 Am i right Thnx in adv 🙏🙏

[@MDataFinnovatics]

Yes, if you have 8 conditions, you must use the IF formula 7 times. However, it is also dependent on the type of condition that you have. If your condition is in text format, you can use the VLOOKUP formula instead, which will make the formula shorter.

[@deepakbisht5938]

@@MDataFinnovatics do u have any basics on vlook up in your channel that will be helpful

[@MDataFinnovatics]

You can check these 2 videos - kzbin.info/www/bejne/ZpXMc3ytptKEb80 kzbin.info/www/bejne/qaG8qYGdhsyaY7s

[@MDataFinnovatics]

You can watch this video kzbin.info/www/bejne/rF68fqt6gtmpbqc for your query. It will definitely help you.

[@anivichare4354]

How to copy and paste when filter is applied.

[@MDataFinnovatics]

You can use Ctrl + C to copy and Ctrl + V to paste the data even if there is filter.

[@Unfiltered_ind]

Sir condition 0> nhi samjh aa Raha please reply me back

[@MDataFinnovatics]

Satvinder, could you please tell us in details exactly kya samajh nahi aa raha hai aapko, so that we will try our level best to explain you in detail!!

[@TheNarendrasinh]

हेलो सर, मुजे एक फार्मूला सिखये मुजे तारीख वाईझ हर एक बंदे के अलग अलग चीझ सेल की टोटल है उसमें मुजे जो मैक्सीमम सेल है उसी बंदे का नाम सो करे इसी प्रकार के पोर्मूले की जरूरत है।

[@MDataFinnovatics]

You can use Index + Match + Max Formula to get the answer.

[@sifatahmed8092]

in 3rd condition, cant we use "if -and "to indicate "average" comment ?

[@MDataFinnovatics]

If you wanna use "And" formula along with "If" Formula it will be bit lengthy because here we need 3 outputs (Excellent, Good, Average). So, nested If is the best solution here.

[@harubindas1373]

Koi btayega ki 15 se jyada ho to 15 output aaye or 15 se kam h to vhi value output aaye jese 12 h to 12 output iska formula kya hoga

[@MDataFinnovatics]

Hi Haru, You can easily get the desired results by using IF formula. Suppose you have the value in A1 cell then use this formula: =IF(A1>15,15,A1)

[@bla3427]

8:00

[@Amazing_India_Journey]

MIS banane ki video chahiye

[@MDataFinnovatics]

Sure Harish. If we get more comments on MIS then we definitely create a video on MIS!

[@Monukumar-360]

Mera ak question hai

[@MDataFinnovatics]

Sure Monu ji, please ask.

[@pkvvibes]

Can you solve my problem

[@MDataFinnovatics]

Please share your problem!

[@pkvvibes]

@@MDataFinnovatics your email address

[@MDataFinnovatics]

Please share your query at [e-mail]

[@Appsandtechnicalsupport]

अगर कोई बच्चा सभी विषयों में 0 नम्बर लाता है तो उसे absent दिखाना चाहिए और अगर कोई बच्चा एक भी विषय में 17 से कम अंक लाता है। तो उसे फेल दिखाना चाहिए और सभी विषयों में अगर 17 अंक या इससे ज्यादा अंक लाता है तो पास दिखाना चाहिए क्या फार्मला लगाया जाए बताए

[@MDataFinnovatics]

Here you can use Nested IF and Countif formula.

[@Appsandtechnicalsupport]

@@MDataFinnovatics उससे नही हो रहा है

[@MDataFinnovatics]

Please share your formula how are you using

[@Appsandtechnicalsupport]

@@MDataFinnovatics सेंड कर दिया हूँ सर

[@MDataFinnovatics]

kaha share kiya hai aapne?

[@mohamedamineboumeshouli4884]

Don't write the title in English if you are not going to speak it

[@AnupKumar-df6lj]

Cj darcl... HR

[@Nothingcry703]

Saaf nhi dikh raha to kya fayda

[@MDataFinnovatics]

Sir, kya nhi dikh raha aapko?

[@venkygiri8308]

Thank you Dear 😊

[@MDataFinnovatics]

You are welcome Dear!!