Mike is the most humble Excel guru/genius in the world! Thank you, Mike!

Once again you have proven that you are the MASTER!!!! I have learnt so much from you, more than I have ever learnt from a dumb course or MS Help (ha!)

This is by far the very best tutorial video I have come across on KZfaq!!! Your tutorial is so easy to follow and you explained everything to the T! Your video and your explanation are clearer than taking a course! Kudos.

BEST EXCEL TUTORIALS ON THE PLANET!

I am glad that you like the videos! Thanks for liking the videos!

I am glad that you like the videos!

I am glad that you like it! I will keep it up!

I am glad that you like the video!

I am glad that you like it!

I am glad that you like it!!

Thanks a lot! You really are a very good trainer! All your videos are truly awesome! Systematically you explain all options. Hat's off sir!!!

Thank you. You are the BEST teacher I have ever listened to!

My friend, you do a simple superb job on teaching this in a way that regular people like me can understand! KUDOS and Thanks!

I am glad that the videos help!

Yes, I am aware of that! You are welcome for the tutorials!

Thank you XLSFUN - your voice sounds a bit tired - please take care yourself - you are our angel !

You are welcome!

Thanks! I am glad that the videos help!

Keep it up !!! If u have a fan club, we all will become its members.. u r really systematic and planned.. Hats off to you Sir...

I always enjoy how you explain excel, it is really fun! ExcelIsFun!!!!

Thank you so much!! You really made Excel fun and easy to learn! I used to avoid Excel and now I really love it. Explaining Excel functions are not an easy thing to do, so I appreciate the great help.

Your explanation is very clear. I wouldn't mind paying to learn this from you.

Excellent! I’ve really been struggling with IF AND OR and I think this explanation might have finally made it sink in for me! Thank you!

brilliant - thanks, you presentation was scaffolded step by step from simple to complex and your explanations were clear

The best ever. Thank you so much, you are helping change the world one trick at a time.

Great video with clearly explained content! You really are an excellent trainer, I like how you vocalize the UI action / shortcut you are doing instead of just doing it silently. I always dragged to extend a formula, didn't know about double clicking to "send it down". I also learned the F4 trick from this video for locking cells. Nice job!

Many thanks! You explain more better than official Office online

Thanks!

Just found and subscribed to your channel! Your a excellent teacher and excel god! Thank You!

not only My Favorite Channel but also the best for everyone

Love logical formulas. Thanks Mike.

Thank you for this.

Really enjoyable - I feel much more confident with various functions. Thank you.

Excellent explanations and not too hurried, even I could get it right! Keep on inspiring us dummies :)

Thanks! This helped my understanding a lot.

Your tutorials are amazing Mike. Being bad at Excel has hindered me from gaining grabbing good professional opportunities before. Not anymore :)

This tutorial is great. I am getting to it bit by bit. thanks a million.

Fantastic tutorial. I'm somewhat fuzzy on the IF, AND, OR formulas but this is tutorial is easy to follow and well structured.

Simply great explanation.

THANK YOU SO MUCH YOU SAVED ME SO MANY HOURS!

Many many thanks! This is your 3rd video I am watching. You saved the day! (by the way, nice voice and arthrosis. I mean, very clear.)

Happy 4th!!

"BOOM!" Thanks for the help

Great explanation, thank you.

Thanks, Great Examples!

Finally, like Yoda, A TRUE MASTER!!!

Great tutorial! Thank you so much for all your videos. They are simply AWESOME!

You are genius ... rhanks a lot for teach us...pray for you sir

Your work is excellence

it is very simple to understand...........Thank u sir

Good sysmetical explanation. 👍

Hey, I really appreciate your videos, I've learned a LOT from your lessons. I have one question though: Is there a video where you explain how torefer to an array of cells using the IF function? For example: =IF(AND(A1=B3,OR(A2=B4:B10)))- this one doesnt work obviously because IF doesnt "understand" the reference to an array.

Very well presented many thanks:)

Thanks to this video I was able to solve a question that I spent multiple hours on, in under 5 mins.

Great video!! Happy 4th of July. Got Don't Fear The Spreadsheet, quite a book.

Brilliant tut!!

thanks!! easy and direct to the tgt also for non English speakers

You are fabulous! ;-) I learn more from your site than any other!

great tutorial as always

Me too!

Your awesome Mike!!!

Thankyou sir... Very nice and good explanation..

Best video ever.

You are awesome!!!

AWESOME..........!!

very good trainer

Nyce productive one thanks

Thanks a lot! You really are a very good trainer! All your videos are truly awesome! Systematically you explain all options. I would like know can we make data base software for HRMS wherein we can by simply putting employee code it shows all the data like first nam, middle name, surname, designation, address, department, ctc, job profile, d.o.b, d.o.j, age in years, date of retirement like so.

thanks for the nice tutorial

Thanks for the big help Sir.

Excellent, very understandable

Thank you so much

def helpful... thanks! :)

Very useful and resourceful to me! Thx for this effort! I really learnt a lot :)))

I enjoy & love to watch yr video...explanation is very clear & straight forward !!I'm having some problems... by trying to insert the "Qty in stk" to the "Pending orders".What formula will best suit the following conditions ?1. "Product code" must be the same for these two files :"Pending Orders" & "Stk on hand".2. "Supplier id" must also be the same for these two files3. "Customer id" must be the same for these two files with additional conditions :a) If "Cust_id = PRO027" must specify clearly on result column as- Example : "PRO027=1,000" (to sum up the qty for PRO027 under "Stk on hand".b) Sometimes, per "Pending Order" line item may have two results ##:##1) Qty in stk (condition 1 to 3 are meet) &##2) "PRO027=1,000"4. When the result for above 1 to 3 is meet will need to 'sum' all the qty for repeated "product code/Cust/Sup" under the "Stk on hand" qty.Thank you in advance for your help.

Yes you can use conditional formatting.

i am your number one fan! thank you for this...;-)

Thank you for the detailed information. I just have a question. I am needed to make an excel chart that includes a percentage in one column, number of sales in one column (minimum a person has to make is 44) and number of mistakes in a month. To sum this database into a final gradin rate, I would need to come up with a function (the if function seems to be the one in my opinion). My question to you is, which function(s?) should I be using and how can I integrate a data that is different than the other ( percentage-number)? Thank you very much in advance

athsnks a lot and God bless u

Your learning function(Trick) nice i like it

Wow i think i have now grasp all the IF function(or (and 👍👍

HELLO ,is it possible to link the content of the box with number (10) in the "NEW FORMATING RULE" window at conditional formating >>format only top or bottom ranked values , with an external cell of the sheet ? Thanks ....

your videos are so helpful, thank you. How would I write IF a range of cells = yes or n/a then another cell = yes, but if any = no then the cell = no. I could do each individually but wonder if there is a faster way.

Awesome!

Hi, thanks for your nice tutorial. i see in your tutorial you use $ sign in the function by shortcut key, pls teach me how to use $ sing in the formula by shortcut key. thanks!

It is really very nice :-)

Awsm videos...i wanna ask if there is any fucntion thru which i can map a field that the value enter in that colum should range between only 2 values or the value put should not b more than the defined value ?

I would like to combine these two IF functions in one cell - =IF(K134="M1-W1",J134,IF(K134="Monthly",J134,0)) and =IF(F4="Completed",0,IF(F4="PR Delivered to Logs",C4))

I love this

excellent !! I LIKE TOO MUCH YOUR VIDEOS SON !!! CHEERS !! WASSUP !!!!!!!!!!!!!

Hey ExcelIsFun, Did you know about the 'evaluate formula'-function in Excel. It could be very useful, also for in tutorials I think.

fantastic

Thank you so much sir. Step by step I tried with Excel sheet and everything worked fine. Nice explanation. I Easily learnt nesting of IF, AND, OR.

thank bro ;)

I your alright Excelisfun guy!!! 👍

Who else just did their homework in 2020 with the help of this oldie but goodie?!!!

Thanks dad

i want to know a conditon if any cell value 15 then another which i selected is value is 1, and if 18 then 2 if 26 then 3, how can i make it

Your video provides me solution to most excel issues I've had living up to its name "Excellisfun". I am having trouble getting one to work. I tried using a nested if and function for a large number of data but no success yet. The condition are.....Vendor list = COD if series starts with "A" (A12345) and Pline = XY, Vendor=DOM if series starts with "A" (A12345) and Pline is BL, Vendor = DMM if series starts with "K" ( K12345) and Pline is DL, CL (not XY or BL) and Vendor = BUD if series does not start with a letter (12345) and Pline is XY,BL,DL,CL and other. Since I am only interested with the first letter in the "series" column, I included a left function. The single formula works by itself, but when I have all three if functions nested, it gives a #Value error. Single formula is =if(and(left(series,1)="A",Pline="XY"),"COD","BUD". my nested if function is =if(and(left(series,1)="A",Pline=""XY"),"COD"),if(and(left(series,1)="A",Pline="BL"),DOM,if(and(left(series,1)="K",Pline"XY","BL", "DMM"),"BUD"). Please tell me, wher did it go wrong or is it completely wrong.

Can we use Wildcard characters(*,?,~) with if with logical functions