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.😃😁😁
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!
Thank you so much, my dear teacher. I watched so many good videos on UA-cam for the same topic however I didn't find one single video that covered all the combinations that you had shown. For the last two days I have been crazily searching for one good video... thank you so much and truly appreciate for your valuable time and efforts.
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.
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.
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.
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!!
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?
Mam, if 1st condition or 2nd condition match than write A1 or A2 please provide formula for this. (any one condition match) write A1 no condition match write b2. please reply.
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
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.
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 ?
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?
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
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
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
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.
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.😃😁😁
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!
Hi Christophe, many thanks for your feedback - all the best!
THANK YOU! HELPED ME WITH MY EXCEL STATS COURSE. Love from Toronto
Thank you so much, my dear teacher. I watched so many good videos on UA-cam for the same topic however I didn't find one single video that covered all the combinations that you had shown. For the last two days I have been crazily searching for one good video... thank you so much and truly appreciate for your valuable time and efforts.
I am so happy I cam e across your page along with the templates!!! Fantastic examples
One of the best tutorials. Worth watching 🎉
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
Glad it was helpful! Hope the interview went well!
The best if function in youtube!!!!!! the logic is explained so clearly!
Thanks mam your pronunciation and your voice is an exceptional .Your method of explanation is phenomenonal
Thank you I finally solved my IF/AND formula and you saved my life or my job :))))) Hugs from Budapest
Woooow woooow woooow... Wonderfully explained.. just awesome 🔥🔥🔥
Great!!!! very nicely explained ..thank you very much...for sharing ...
Thank you. You are an excellent teacher.
Very nice presentation and useful tricks
Thank you so much for the tutorial. It 's very clear and simple to understand. Very impressive work !
Thanks for your feedback - glad it helped!
This is a good explanation of the IF AND OR combinations. Why would you charge for the practice sheet. Thank you this really helped.
In addition to the thanks already given by these old friends, 2024 this tutorial is still very useful, thank you!
Thank you so much. Your video helped me so much
You're welcome!
love your teaching style. please keep video coming
Thank you . That was really helpful .
This is great, thanks!
Thank you so much for well explained topic with very clear examples.
Excellent, thanks baby!!!
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.
Excellent video!!
Great tutorial! Thanks for sharing!
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
Thanks for the clear explanation :)
After years of been confused with this, I finally understood it thanks to this wonderful teacher
EXCELLENT..........Neat Explanation...
Thanks!
THANK YOU
Very well explained and easy to follow. Thank you
Thanks, Elizabeth!
Very very useful❤
Thank you , I was struggling to get a clear logic.
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.
Thnks so much for this video..so much help..may god bless you
Great Job, i like it.
Thank you so much!
such nice video, loved it. Tnq so much
Most welcome 😊
Dear Madam - Superb. Thanks.
Very clear. Much appreciated.
Great, thank you so much.
Very help full , thanks
Glad it helped
I appreciate this tutorial, very well explain, thank you
Superb explanation 👌
Nice video, Neat explanation
Excellent explanation thanks. I was struggling with the AND/OR combination but i see the mistake i was making
Thanks so much
you are welcome
Very informative, clear and well-rounded. Thanks a lot.
Thanks for your feedback!
Great instructional video with really helpful workbook display. Awesome! 😉
Thanks so much!
Thanks for this (on behalf of Leanne and Alex)
It helped..thanks a lot..🙏
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.
You saved my day! Its the thing that i have been looking for. Thank you for the good content and expertise
Glad I could help!
Helped a bunch, thx
That was awesome lots of thanks
You are welcome!
Very useful , very thanks to you .
Thanks for the feedback!
great
Thank you so much!
XLNT EXPLANATION. TANX- A - LOT
absolutely clear. Thank you
You are welcome!
thank you so much for ypur help
Hi. Just bumped into your channel. Can you do a video of Cell referencing in excel the way you explained this one.
IF FORMUAL TO CHNAGE -VE TO +VE VALUE . good one
Hey it's awesome can u explain conditional formatting in Excel ❤
Clear cut explaination
Uhh made us understand complicated formulas in the simplest way
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!!
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?
Thanks, this helps a ton for finding local minima and maxima.
Dang, this was good!
What if it has a drop down list? How the formula will change?
Explain verygood
Thanks!
Excellent
Thank you! Cheers!
do you have any problem to give sheet for practice
Many for template?!
Good one
Thanks
Mam, if 1st condition or 2nd condition match than write A1 or A2 please provide formula for this.
(any one condition match) write A1
no condition match write b2.
please reply.
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
Thank you for your feedback and all the best"
Nice video
Thanks
How we can apply IF AND formula whole column or Row?
Why do you use the addition symbol and not the equals symbol at the start of your formula?
Thank you so much
Can I count p=1,s=2,H=1/2 in one cell
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
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.
i like your voice
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 ?
💕thank you❤️
awesome
Love You ❤
Thanks.
You are welcome!
A question though, what happens if you change the sequence of the functions how does that change the mechanism of the formula?
Well overall tutorial was fabulous but you should upload the excel workbook/File to practice on that.
Thanks
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?
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
Welche Formel soll ich verwenden, wenn ich mehrere Folgen an ein IF knüpfen möchte?
thank you, i wanna cry bcs this help me alot T-T
You are welcome :)
HI, It will be very useful if you could please provide the excel sheet for me to practice it. Can you please do that?
Please the worksheet
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
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
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.