IF AND OR Formula in Excel with MULTIPLE CONDITIONS

Рет қаралды 626,259

Күн бұрын

⚡ GET THE EXCEL TEMPLATE HERE: payhip.com/b/ocaH8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ In this video you will learn how to use the IF AND OR function combination in Excel with multiple conditions.
This step-by-step Excel tutorial will show you how to use the IF function together with AND function or OR function in Excel 2019 in a variety of different combinations and with two or more conditions.
Based on the classic Excel IF formula, we will first next the AND function as well as the OR function to create IF AND OR formula to test if all of the tested conditions are true.
Second, we will extend the IF function in Excel and next OR formula and the AND formula to create IF OR AND function combination in Excel to test if at least one of several conditions is true.
🚩 TABLE OF CONTENTS
00:00 Introduction
00:32 Recap of the IF function
02:47 IF + AND function combination
06:23 IF, AND, OR function combination with multiple criteria
10:39 IF + OR function combination
13:03 IF, AND, OR function combination with multiple criteria
16:40 Comparison of IF AND function combination and IF OR Excel function combination
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🔥 Want more professional PowerPoint presentation tips, slide designs & techniques?
Subscribe ► / @presentationmastery
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
MY FAVORITE OFFICE GEAR*
🖥️ My LG curved ultra-widescreen monitor: amzn.to/3ztOlkr
🐭 My Logitech wireless mouse MX Master: amzn.to/3Uao8jz
🎧 My Bose noise cancelling earphones: amzn.to/3UjbIWd
🔊 My Jabra speaker for video conferences: amzn.to/3fsyuMf
💻 My Lenovo Thinkpad X1 Carbon workhorse notebook: amzn.to/3WkevQE
🛋️ My BenQ ScreenBar: amzn.to/3WoUyIC
🆙 My height adjustable standing desk: amzn.to/3DxQBJ0
💡 My Philips Hue smart light bars: amzn.to/3TSX0W4
MY FAVORITE SOFTWARE/TOOLS*
📊 Microsoft 365: amzn.to/3zxnjcc
🔊 Where I listen to 30+ audio books per year: amzn.to/3gUOUgV
* Links are Affiliate links. This means I earn a small revenue share whenever a qualifying purchase is made via the link. The price for you stays the same = win/win 👍
#IfFunction #MultipleConditions #ExcelTutorial

Пікірлер: 135

@user-yu1rk7sf9t 2 жыл бұрын

The only thing which I can give you that is only by subscribing your channel and by liking your hard work which you have devoted for us.Thanku thanku so much.😃😁😁

@christophecaron6963 3 жыл бұрын

Looking at the complexity of some of the formulas, it is very clearly explained! Your examples are well structured and presented. Congratulations! It was not an easy one to demo. Many thanks!

@PresentationMastery 2 жыл бұрын

Hi Christophe, many thanks for your feedback - all the best!

@phonglam9552 3 жыл бұрын

Thank you so much for the tutorial. It 's very clear and simple to understand. Very impressive work !

@PresentationMastery 2 жыл бұрын

Thanks for your feedback - glad it helped!

@sarobidygabriel5000 Ай бұрын

In addition to the thanks already given by these old friends, 2024 this tutorial is still very useful, thank you!

@bryank5502 Жыл бұрын

THANK YOU! HELPED ME WITH MY EXCEL STATS COURSE. Love from Toronto

@ch00226855 Жыл бұрын

The best if function in youtube!!!!!! the logic is explained so clearly!

@hebakamal3757 3 жыл бұрын

Very informative, clear and well-rounded. Thanks a lot.

@PresentationMastery 2 жыл бұрын

Thanks for your feedback!

@harrisakuffoamon4704 2 жыл бұрын

After years of been confused with this, I finally understood it thanks to this wonderful teacher

@CVPcreations Жыл бұрын

I had a long-standing problem in getting done some of my personal work using these multiple conditions, functions. Today I got the answer. Really helpful. Thank you very much.

@stevenintexas6947 Жыл бұрын

Thank you. You are an excellent teacher.

@kalhussain787 2 жыл бұрын

Great instructional video with really helpful workbook display. Awesome! 😉

@PresentationMastery 2 жыл бұрын

Thanks so much!

@1188479 2 жыл бұрын

I am glad to find this tutorial at the last minute when I'm doing the excel test for the job by online. It's easy to understand. Thank you

@PresentationMastery 2 жыл бұрын

Glad it was helpful! Hope the interview went well!

@TobyAnderson Жыл бұрын

Thanks, this helps a ton for finding local minima and maxima.

@pipo441 2 жыл бұрын

Very clear. Much appreciated.

@MrsEngineer11 3 жыл бұрын

Very well explained and easy to follow. Thank you

@PresentationMastery 3 жыл бұрын

Thanks, Elizabeth!

@gibsonbjs1 9 ай бұрын

Thank you so much for well explained topic with very clear examples.

@vvdd903 2 жыл бұрын

love your teaching style. please keep video coming

@DataVenture 2 жыл бұрын

You saved my day! Its the thing that i have been looking for. Thank you for the good content and expertise

@PresentationMastery 2 жыл бұрын

Glad I could help!

@fabianokwilagwe7395 Жыл бұрын

I appreciate this tutorial, very well explain, thank you

@johnvsf Жыл бұрын

Great tutorial! Thanks for sharing!

@baracuzzzz 3 жыл бұрын

absolutely clear. Thank you

@PresentationMastery 2 жыл бұрын

You are welcome!

@nawazahmednawazahmed9467 10 ай бұрын

Thanks mam your pronunciation and your voice is an exceptional .Your method of explanation is phenomenonal

@shrishailparma3811 9 ай бұрын

Great!!!! very nicely explained ..thank you very much...for sharing ...

@nagitutunji3924 Жыл бұрын

Thank you . That was really helpful .

@rabona8843 22 күн бұрын

Thanks for the clear explanation :)

@barryh7387 3 жыл бұрын

Excellent explanation thanks. I was struggling with the AND/OR combination but i see the mistake i was making Thanks so much

@PresentationMastery 2 жыл бұрын

you are welcome

@shaimaaali6977 3 жыл бұрын

Very useful , very thanks to you .

@PresentationMastery 3 жыл бұрын

Thanks for the feedback!

@amirulshafiq9652 2 жыл бұрын

Thnks so much for this video..so much help..may god bless you

@AbuAbidulziz2024 Ай бұрын

Great, thank you so much.

@leannrollans2907 2 жыл бұрын

Excellent video!!

@skvallakat 7 ай бұрын

Woooow woooow woooow... Wonderfully explained.. just awesome 🔥🔥🔥

@universalsanjay3526 Жыл бұрын

It was very helpful thank you 🤯

@hravichandran 3 жыл бұрын

XLNT EXPLANATION. TANX- A - LOT

@buckeye4228 2 жыл бұрын

Helped a bunch, thx

@devangthakkar6847 2 жыл бұрын

Dear Madam - Superb. Thanks.

@kishorubale8508 3 жыл бұрын

That was awesome lots of thanks

@PresentationMastery 2 жыл бұрын

You are welcome!

@dilkymadushani1034 Ай бұрын

Thank you so much❤️

@athulawijepala1871 2 жыл бұрын

Thank you so much. Your video helped me so much

@PresentationMastery 2 жыл бұрын

You're welcome!

@antoniotaco366 2 жыл бұрын

Excellent, thanks baby!!!

@krithish1 2 жыл бұрын

Thank you for sharing this, indeed useful in daily work.. Would appreciate if you can increase the font size / zoom page for clear visibility of the contents shared.

@hiralpayak1272 4 ай бұрын

It helped..thanks a lot..🙏

@rameshkasun1411 Жыл бұрын

Superb explanation 👌

@mauriciocebada2863 2 жыл бұрын

Gerat video, thank you for sharing, it helps a lot when you shared your workbook to follow along and practice otherwise we just follow along

@PresentationMastery 2 жыл бұрын

Thank you for your feedback and all the best"

@dsingh8513 2 жыл бұрын

Very nice presentation and useful tricks

@Salma-ei4if 2 жыл бұрын

thank you so much for ypur help

@ramk1969 3 жыл бұрын

EXCELLENT..........Neat Explanation...

@PresentationMastery 2 жыл бұрын

Thanks!

@neilkanagaratnam7445 2 жыл бұрын

Very help full , thanks

@PresentationMastery 2 жыл бұрын

Glad it helped

@sdllds9726 2 жыл бұрын

Thanks

@mathsmanju4868 Жыл бұрын

Thank you so much

@KK2UK 9 ай бұрын

Clear cut explaination

@zacwren3950 3 жыл бұрын

I’m trying to create a formula to count (text) in (different rows that are separate) if (text b) is (text c). Having issues getting it to allow me to run the multiple pairs of ranges. Any tips would be awesome

@AmandeepSingh-rh3zz Жыл бұрын

Thank you , I was struggling to get a clear logic.

@pandharinathjoshi6565 Жыл бұрын

Nice video, Neat explanation

@briancaffrey1892 Жыл бұрын

Thanks for this (on behalf of Leanne and Alex)

@dassuvarthi8978 6 ай бұрын

Love You ❤

@pranjaldas8037 Жыл бұрын

💕thank you❤️

@shailesht592 3 жыл бұрын

Thanks.

@PresentationMastery 3 жыл бұрын

You are welcome!

@m.n.953 2 жыл бұрын

Thank you very much for nice explenation and clear excamples. i wish if you can always drop files exampeles for downloading to make training of the functions. thanks again.

@mch6893 8 ай бұрын

Dang, this was good!

@emilland07 2 жыл бұрын

Great Job, i like it.

@PresentationMastery 2 жыл бұрын

Thank you so much!

@funnybaby184 10 ай бұрын

IF FORMUAL TO CHNAGE -VE TO +VE VALUE . good one

@ningappatotigara1479 2 жыл бұрын

such nice video, loved it. Tnq so much

@PresentationMastery 2 жыл бұрын

Most welcome 😊

@dagobertduck4366 Жыл бұрын

awesome

@Dravidan1971 2 жыл бұрын

Thanks it's great. Hi i want to know that weather a formula could be constructed for (if two cells has a combination of values matching in a different range (fixed range cells) then it should take the value in the next near cell of the matching values?) what logical functions we have to use for this? If and Find or what?

@vitthalbathe8253 3 ай бұрын

If annual salary 500001 to 1000000 than LTA pay 15000 yearly and monthly 15000/12 and 1000001 to 1500000 than LTA paid 20000 yearly and monthly 20000/12 so how to put formula in both case in one single cell

@Isi7859 2 жыл бұрын

Thank you I finally solved my IF/AND formula and you saved my life or my job :))))) Hugs from Budapest

@samishmael Жыл бұрын

I have been enlightened by your video, but I will love it if you zoom the screen next time so the illustration can be seen clearly. Thank you

@adarshpandey8314 Жыл бұрын

Uhh made us understand complicated formulas in the simplest way

@mohamedelbaz8667 3 жыл бұрын

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

@hamzaihsan5298 2 жыл бұрын

Well overall tutorial was fabulous but you should upload the excel workbook/File to practice on that.

@user-uz1fg6kc8r 5 ай бұрын

Hey it's awesome can u explain conditional formatting in Excel ❤

@hggh7661 2 жыл бұрын

Explain verygood

@PresentationMastery 2 жыл бұрын

Thanks!

@edicionexpress8559 2 жыл бұрын

Excellent

@PresentationMastery 2 жыл бұрын

Thank you! Cheers!

@kcphillips4695 8 ай бұрын

Excellent tutorial. Would you please do a video where you can create a formula that deals with time? If the time is between 6 o'clock and 7 o'clock display a1. If it is between 7:01 and 8:00 display a 2. If it is between 8:01 and 9?:00 display a 3. What I cannot seem to figure out is the 3 condition. I can figure out how to do 2 of them but not the third. I actually need to do a 4th one for my project but if you can show me 3 I am pretty sure I can do the 4th time period. Thank you in advance.

@meranism673 2 жыл бұрын

Thank you for the information sir. I would like to see if there is a way to apply the same method for several columns? I have a sheet where I input my monthly expenses and I separated it by months. So each month has it's own expenses in different column. Is there a way to get a sum for a specific expense, let say (GAS)? I would really appreciate it if you could help me. Other wise the way I do it now I get a sum for each month and then add up all those numbers to get a sum of all. That's taking a long time to put the same equation for each month over and over again. =SUMIF(A3:A25,"*"&AI5&"*",B3:B25)+SUMIF(C3:C25,"*"&AI5&"*",D3:D25) - this is what I use. but I have to do it for 12 months. Is there a shortcut for achieving the same result?

@bazigarfromyt Жыл бұрын

i like your voice

@pipo441 2 жыл бұрын

A question though, what happens if you change the sequence of the functions how does that change the mechanism of the formula?

@powellmbilima3340 2 жыл бұрын

Good one

@PresentationMastery 2 жыл бұрын

Thanks

@davidtopp1972 Жыл бұрын

Wonderful video! I am not sure, but this may be the answer to what I am trying to create. I am trying a somewhat unique way of laying out an Excel checkbook register. I would like both my debits and credits in a single column and have the values in that column automatically format to negative or positive depending on the transaction type. I would have a transaction type column with a drop-down of Withdrawal, Deposit, Transfer_Out, Transfer_In. The Deposits and Transfer_In would be positive; and the Withdrawals and Transfer_Out would be negative. There is also a running balance column. I could e-mail you a sample file if there is a way to build this. Many Thanks in Advance!

@ananddubey4226 2 жыл бұрын

great

@PresentationMastery 2 жыл бұрын

Thank you so much!

@Antonio-ij5zy Жыл бұрын

Hi. Yor explanation was very clear and I'm one of your new thousands of subscribers. I just don't seem to figure out how to use this is my problem. > I want to divide a merged cell B1:B3 to get the share value for each A1, A2, A3 in row C1, C2, C3. It becomes complicated when there are cells that are not merged, (value in B4=value in C4), and sometimes merged cells are 2 to 6 cells. So, if 6 cells in B are merged, what is 6 rows in A share value in each 6 rows in C? I hope you can discuss this in your future videos. Thank you so much!!

@biyaprincess7385 2 жыл бұрын

Nice video

@PresentationMastery 2 жыл бұрын

Thanks

@samiabhatti9238 Жыл бұрын

HI, It will be very useful if you could please provide the excel sheet for me to practice it. Can you please do that?

@anmac6910 Жыл бұрын

I already have duplicated an entire row for specific text if found in the column. But now, I want to add a secondary duplicate to find all values based on those highlighted cell's colour and value contained within them ? How can I do that ?

@coldavenue2325 3 жыл бұрын

Welche Formel soll ich verwenden, wenn ich mehrere Folgen an ein IF knüpfen möchte?

@ahmadhaziq3802 2 жыл бұрын

thank you, i wanna cry bcs this help me alot T-T

@PresentationMastery 2 жыл бұрын

You are welcome :)

@drnithinkm 2 жыл бұрын

What if it has a drop down list? How the formula will change?

@samueltienko2741 2 жыл бұрын

I HAVE TWO ARRAYS THAT CONTAIN NUMBERS THAT RANGE FROM 1 TO 30 AND I ASK EXCEL TO LIST THE TRIPLE AMONG THESE NUMBERS THAT ARE SIDE BY SIDE IN EACH OF THESE TWO ARRAYS FROM LEFT TO RIGHT UP AND DOWN AND LIST THEM WRITE WHICH FORMULA SHOULD I USE HELP ME PLEASE

@tehsinbashir1292 2 жыл бұрын

How we can apply IF AND formula whole column or Row?

@ahmaddaris8764 2 жыл бұрын

I think you should not forget to told every fixed cell with the F4 pressing, reminding that it's always had to be done. 👍👍

@PresentationMastery 2 жыл бұрын

Good point!

@fathimaz999 5 ай бұрын

👍👍

@user-lp9yn9kv7r 11 ай бұрын

Why do you use the addition symbol and not the equals symbol at the start of your formula?

@dinominati8279 2 жыл бұрын

do you have any problem to give sheet for practice

@epicurean9866 Жыл бұрын

What if two columns will be interpreted. please help me only two columns to come up with interpretation Ex. c1 is frustration and e1 is instructional- the interpretation is frustration if c1 is instructional and e1 is independent- the interpretation is instructional if c1 is independent and e1 is independent- the interpretation is independent I have two cells to be interpreted please help me out.

@___its_me_kittu_x4 5 ай бұрын

Can I count p=1,s=2,H=1/2 in one cell

@production.coppergat 2 жыл бұрын

CAN YOU HELP ME HOW TO SHOW THE FOLLOWING GIVEN BELOW; 8:15AM TO 8:30AM MENTION -1HOUR, 8:31 TO 9:00 MENTION -2HOUR, 9:01 MENTION -4HOURS, 12:00PM MENTION -4HOURS, 3:00PM MENTION -2HOURS, 4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?