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

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

[@manavcaculo2976]

solved my problem in a minute, thank you!!

[@MDataFinnovatics]

You're welcome Manav Caculo!

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

[@muraligopal801]

Very clear explanation thanks for sharing

[@MDataFinnovatics]

Glad it was helpful!

[@sudeernarayan5411]

Well explained, thanks a lot sir🙏

[@Gamingvibesop]

EXCELLENT WITH DEPTH

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

[@nirajborkar7817]

Excellent sir. Nice discription, very important

[@MDataFinnovatics]

Thank you Niraj Borkar!

[@prashant984]

Very nicely elaborated thanks it's worthy

[@MDataFinnovatics]

Thank you, Prashant Mishra.

[@shubhamarote4685]

Really good teaching 😊

[@MDataFinnovatics]

Thank you Shubham!

[@suklasukla2468]

Thnkeu so much sir🎉🎉

[@MDataFinnovatics]

Thank you!

[@lavanya1758]

perfect and excellent your video👌

[@MDataFinnovatics]

Thank you Lavanya!!

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

[@rohitjadhav1527]

Awesome Sir..thank you :)

[@MDataFinnovatics]

Your welcome Rohit Jadhav!!

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

[@dipakpapu]

Great👍

[@laveshghadi2200]

Thanks a lot sir

[@MDataFinnovatics]

Thank you Lavesh Ghadi!

[@myknowledgeeducation.1745]

Helpful for me..thanks 👍

[@MDataFinnovatics]

Your Welcome MS creater!!

[@shobzkhan2850]

Very nice.. Keep up the good work

[@MDataFinnovatics]

Thank you shobz!

[@shahzstudio3889]

Excellent video

[@MDataFinnovatics]

Thank you very much Shahz!

[@SanjaySingh-su4rn]

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

[@MDataFinnovatics]

Thank Sanjay ji!

[@bakervai7658]

Thanku sir 👍👍👍👍

[@MDataFinnovatics]

Your Welcome Baker Vai!!

[@charansalve2622]

Thank you for good knowledge!

[@MDataFinnovatics]

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

[@soumya_adamyavlogs]

Very helpful

[@MDataFinnovatics]

Thank you Adamya!

[@manojchaursia6501]

Nice video sir ji

[@MDataFinnovatics]

Thank you Manoj Chaursia!

[@sachinjagalekar7288]

excellent boss

[@MDataFinnovatics]

Thank you Sachin..

[@rachanacharan1411]

Excellent sir .. thank you so much

[@MDataFinnovatics]

Thank you Rachana Charan for liking the videos!

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

[@AbdulRasheed-qx3iq]

Well done sir.

[@MDataFinnovatics]

Thank you Abdul!

[@narendersapra1685]

Gr8 learnings for all

[@MDataFinnovatics]

Thank you Sir...

[@DelhiKPahadi]

Simple and greAt explain

[@MDataFinnovatics]

Thanks Suraj Bisht!!

[@naturefeels9521]

Cool vedio sir or bnayeyaii 👍

[@MDataFinnovatics]

Thanks and sure

[@Isaiah9.6]

Superb! Just wow!

[@MDataFinnovatics]

Thanks a lot Leena!

[@murarikumar165]

great video with excellent explanation

[@MDataFinnovatics]

Thank you for your support!

[@ajaychoubey368]

Very helpful sir 😊

[@MDataFinnovatics]

Thank you!

[@PuranKumarBhuwanta]

Excellent Sir...

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

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

[@shriyasejpal661]

Thanks, this helped!

[@debolinadewanghosh4236]

excellent

[@MDataFinnovatics]

Thank you Debolinadewanghosh!

[@kashifqasim8069]

Well explained

[@MDataFinnovatics]

Thanks Kashif!

[@VeSecret]

Very well explained 👍

[@MDataFinnovatics]

Thank you 🙂

[@dkboss5439]

❤️❤️ great

[@MDataFinnovatics]

Thank you Dk Boss!

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

[@nidhiverma9656]

Superb

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

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

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

[@venkygiri8308]

Thank you Dear 😊

[@MDataFinnovatics]

You are welcome Dear!!

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

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

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

[@LeadYouLife]

Explained very well Thanks

[@MDataFinnovatics]

Thank you!

[@priyankahaware9256]

Best video

[@MDataFinnovatics]

Thank you Priyanka!!

[@ajaychoubey368]

Sir offset ke upar bhi ek video bana do

[@MDataFinnovatics]

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

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

[@nageshkaushik315]

Wow sir good initiate mujhe bhi sikhna h

[@MDataFinnovatics]

Thanks...

[@ajayparashar8603]

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

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

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

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

[@Amazing_India_Journey]

Very nice

[@MDataFinnovatics]

Thanks Harish Pardhan!

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

[@dilshadahmed5918]

Repeat value per vlookup with condition

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[@Monukumar-360]

Mera ak question hai

[@MDataFinnovatics]

Sure Monu ji, please ask.

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

[@pkvvibes]

Can you solve my problem

[@MDataFinnovatics]

Please share your problem!

[@pkvvibes]

@@MDataFinnovatics your email address

[@MDataFinnovatics]

Please share your query at [e-mail]

[@TheNarendrasinh]

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

[@MDataFinnovatics]

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

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

[@AnupKumar-df6lj]

Cj darcl... HR

[@Nothingcry703]

Saaf nhi dikh raha to kya fayda

[@MDataFinnovatics]

Sir, kya nhi dikh raha aapko?

[@mohamedamineboumeshouli4884]

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

[@abhaychauhan253]

Thankyou so much 😊

[@MDataFinnovatics]

Abhay, your welcome. 😊