This is the best training channel for Excel. I no longer search KZitem. I just search through this channel for all that I need!!!
@excelisfun
13 жыл бұрын
I am glad that you like the video!
@LuluNero
14 жыл бұрын
You are a WONDERFUL TRAINER. I am happy to have found someone who teaches with such passion. One wants to listen to your classes (and one doesnt get half asleep or lost btw). Your tricks are very detailed (which I like) and easy to follow. Thanks for doing what you do.
@excelisfun
14 жыл бұрын
I am glad that you like it!!
@excelisfun
15 жыл бұрын
You are welcome! I am happy to hear that you download the workbooks also, many people don't, and thus don't get the full effect!!
@excelisfun
13 жыл бұрын
I am glad that the video helped!
@coreHC
13 жыл бұрын
Man you rock, you didn´t directly solve my problem, but you gave me the perfect idea on how to fix it, you just saved this man some long hours of work
@excelisfun
13 жыл бұрын
You don't have to watch them all, just teh Excel Basics and Highline Excel Class series.
@SuperRobinsont
14 жыл бұрын
I am preparing for Excel vendor test ........so happy to run across this priceless information. Thanks
@excelisfun
11 жыл бұрын
Part 2 to this video shows how to do this: Excel Magic Trick 167p2 IF function formula: 12 Examples!
@excelisfun
15 жыл бұрын
Dear edwindrg, Absolutely!! The IF and logical tests work on words also. If you watch the 9:30 mark of this video you will see a text example. Your Formula, =IF(F2="Ed",1,0), will work just fine! Also, see this video for a laudry list of logical tests with numbers, text, and operators: Excel Magic Trick 62: Logical Formulas & Comparative Operators Here is another video when the IF looks at text: Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel --excelisfun
@excelisfun
13 жыл бұрын
Conditional Formatting. Here is a video that shows many Conditional Formatting tricks: Highline Excel Class 21: Conditional Formatting 12 Examples
@excelisfun
13 жыл бұрын
I am glad that you like them!!!
@excelisfun
12 жыл бұрын
Cool! I am so glad that this channel helps! That is why I post all that I do!
@excelisfun
15 жыл бұрын
If you look down the IF function playlist: 1) You will see the videos about "nesting" IF functions, which will be good for your question about how to have multiple IFs in one formula 2) You will see one for "Medain IF", this one will show how to use IF in an array.
@excelisfun
15 жыл бұрын
Dear MmansoorM , Search for this video and then watch it: Search For Excel Videos Download Excel Workbooks excelisfun This tells you how to use the excelisfun channel. In the Playlist area, I have the Business Math Chapter 3 Playlists with many examples of exactly what you are looking for!! --excelisfun
@rodrigocustodio1955
4 жыл бұрын
Thank you one more time Mike, the best Excel teacher right here, the number one contributor to the sharing of excel knowledge.
@excelisfun
12 жыл бұрын
You are welcome!
@excelisfun
14 жыл бұрын
Don't give up!!
@excelisfun
14 жыл бұрын
I am glad that it helps!
@Da_Crow
15 жыл бұрын
love that u are doing 2007 now !!! Keep it up professor !!!
@excelisfun
14 жыл бұрын
I am glad that it helped!
@excelisfun
12 жыл бұрын
@skydive911 , You are welcome! Did you like the video?
@excelisfun
14 жыл бұрын
Now that's probably an Excel first!
@excelisfun
14 жыл бұрын
Thanks!
@excelisfun
13 жыл бұрын
Data Validation. Try this video title: Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet
@IHaulBoxes
12 жыл бұрын
@ExcelIsFun I liked it very much indeed! In fact... until days ago i thought Excel was stupid complicated and useless but now you got me into the magic!
@excelisfun
14 жыл бұрын
Try this video Playlist with about 70 IF videos: Excel IF Function Formula Tricks
@excelisfun
13 жыл бұрын
search for 'excelisfun' then go to the channel and watch the video that auto plays - it will show the best order to wacth videos.
@excelisfun
15 жыл бұрын
Search for and watch this video tile: Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun
@excelisfun
14 жыл бұрын
It totally depends on what you are trying to accomplish. If you serach for IF VLOOKUP, I have a number of videos that compare the two functions and when it is best to use one over the other.
@excelisfun
14 жыл бұрын
Try this video: Excel Magic Trick #71: Excel Will Talk To You
@excelisfun
15 жыл бұрын
Dear BerPC96, I don't know who Video Professor is. But I have over 800 Excel how to videos. You may be interested in the Excel Basics Series and the Highline Excel Class series. watch this video title to see how to get to these videos and how to download the free book and Excel workbboks: Search For Excel Videos Download Excel Files excelisfun --excelisfun
@excelisfun
14 жыл бұрын
If the House Value is in cell B4 and the Contents Value is in cell C4 this formula may work: =IF(AND(B4>=400000,C4>=15000),0.05,IF(AND(B4>=250000,C4>=10000),0.03,0.015)) but I would test it to see if all cases are covered. For example, if House Value is 300000 and Contents Value is 9000, this formula will yield 0.015.
@excelisfun
14 жыл бұрын
That looks good. Great work!
@excelisfun
12 жыл бұрын
That is too funny! Thank you for the kind compliment!
@leftylee527
13 жыл бұрын
Yeah! It worked! You are the BEST! Thank you, thank you, thank you!
@excelisfun
13 жыл бұрын
If Qty Ordered is in B1Qty Received is in B2, then this formula may work: =IF(AND(B2>=B1,B2
@excelisfun
14 жыл бұрын
It: ="The "&B41&" =" is a Text Formula. & is the join symbol. So the Word "The " is joined with the cell content in B41 and " =" Here is a video about this: Excel Basics #3: Formulas w Cell References
@Mynotoar
15 жыл бұрын
That was especially interesting, the part on using a drop-down list to be able to decide what specifically to calculate. I'm gonna trundle through this playlist in the hope that I find how to use IF in an array / multiple IFs lol.
@754ahmed
10 жыл бұрын
that what the world needs Creative people like you , thanks
@excelisfun
15 жыл бұрын
Dear huyenng, Try this video: Excel Magic Trick #5: Data Validation & VLOOKUP --excelisfun
@munmunmonty
14 жыл бұрын
@ExcelIsFun - You are doing great job mate. Best wishes for your future plans.
@excelisfun
15 жыл бұрын
I don't understand your question. Can you state your question differently?
@excelisfun
15 жыл бұрын
Dear capodaughter , I do not have one video together that shows what you want, but these two together should help: Excel Name Trick #11: Global Percentage Change Formula Excel Magic Trick #103: Pie Chart For Student Scores --excelisfun
@anthonyverdin6743
3 жыл бұрын
I always a blast from the past!!!
@excelisfun
3 жыл бұрын
12 years ago, that is a long time to still be having fun with Excel : )
@excelisfun
15 жыл бұрын
I will!!
@excelisfun
15 жыл бұрын
Dear pwnions08 , You are welcome! --excelisfun
@excelisfun
14 жыл бұрын
Try this formula : =VLOOKUP(DATEDIF(A2,TODAY(),"y"),{0,0;5,1000;10,2000},2) or this: =IF(DATEDIF(A2,TODAY(),"y")
@danicequeabeah7856
10 жыл бұрын
Thanks. This lesson made a great impact on my job.
@excelisfun
14 жыл бұрын
If A1 contains "Yes", try: =IF(A1="Yes",1,2)
@bichngoc2589
14 жыл бұрын
very good tutorial.i find it very helpful.thank you
@excelisfun
14 жыл бұрын
Cool!
@excelisfun
13 жыл бұрын
Try something like: =IF(H2>200,1.1*H2,1.15*H2)
@pwnions08
15 жыл бұрын
amazing what you can find on youtube!! thanks for all your videos .. you have been my best friend this ENTIRE week lol -needsmorefriends XD
@excelisfun
14 жыл бұрын
A formula like this might work: =IF(A1="groceries",B1,"")
@excelisfun
15 жыл бұрын
Dear capodaughter , See this video that I made today: Excel Magic Trick # 267: Percentage Change Formula & Chart --excelisfun
@excelisfun
12 жыл бұрын
@skydive911 , check out latest video I just made: Excel Magic Trick 863: If Sat or Sun, Multiply by 15, Any Other Day Use 14 WEEKDAY & IF Functions youtube [dot] com/watch?v=m82C9uc4Bm0 Formulas like this will work: =IF(WEEKDAY(A5,2)>5,B5*$C$1,B5*$C$2) or =B5*((WEEKDAY(A5,2)>5)+14)
@jimelyson4788
4 жыл бұрын
Thank you Mike
@MESSER8989
13 жыл бұрын
How did you do the drop down functions? (8:45)
@excelisfun
13 жыл бұрын
@llnicholsii , yes, post questions to THE best Excel question site: mrexcel [dot] com/forum
@Finty290
14 жыл бұрын
@ExcelIsFun Hey man thanks alot for your quick response! Yeah I can see where I was going wrong now, nice one :) you rock!! had to refresh myself in excell real quick, your videos helped alot.
@IHaulBoxes
12 жыл бұрын
@ExcelIsFun Wow Wow Wow! That is just AWESOME! I appreciate that so much! You are an ACE Sir! Thank you so very much! Subbed.
@excelisfun
12 жыл бұрын
I do not understand your question.
@excelisfun
15 жыл бұрын
Dear RJ8976, I have a Video Playlist that shows many ways to do this: Various Excel Grade Book Examples If you can't find it, search for and watch this video that will show you how to use the excelisfun channel including finding Playlists: Search For Excel Videos Download Excel Files excelisfun --excelisfun
@llnicholsii
13 жыл бұрын
Excellent video!!! Is there a way to have two IF logical functions with with two different true responses and two different false responses? E.g. IF(AND(A1=B1,"Ok",IF(A1
@IHaulBoxes
12 жыл бұрын
Hi! I was wondering if you also knew a function to do something like: If Day = Saturday or Sunday -> Multiply amount of houres with factor 15 If Not (any other day) -> Multiply amount of houres with factor 14. Could you please help me out? Help would be very much appreciated!!
@Da_Crow
14 жыл бұрын
learning a trick a week! how did you get your excel to "say" the numbers..i can hear it in the background!
@aitchk
11 жыл бұрын
I've posted my question to the MrExceldotcom/forum. Thanks!
@Rourba
14 жыл бұрын
Love Excel, life savor. Sahit.
@DarkLightA12
14 жыл бұрын
I love the automatic speaker! xD
@excelisfun
13 жыл бұрын
Try: =IF(AND(P2>=O2,P2
@excelisfun
13 жыл бұрын
Yes, somrthing like this will work: =IF(D3="","",VLOOKUP....))
@excelisfun
12 жыл бұрын
@skydive911 , cool!
@aitchk
11 жыл бұрын
Daniel, I missed this. Hey thanks! I was using 'or' . . . but that is just one of my problems.
@RJ8976
15 жыл бұрын
I am just learning to use excel and was wondering what the if function would look like when trying to determine which students Passed/Failed (i.e. got a mark of 50% or >). I tried a few different things but I cant get it to work... thanks!
@Finty290
14 жыл бұрын
Hi man, I have a question which I am stuck on, I wonder if you could help... the question is - A premium of 1.5% if the house value figure is less than €250,000, and the contents value figure is less than €10,000; a premium of 3% if the house value figure is less than €400,000, or the contents value figure is less than €15,000; otherwise a premium of 5%. - I have two columns with the house value and contents value, would u have any idea what the formula should look like? thanks alot!
@shafishafi4227
8 жыл бұрын
thanks for the lesson
@JamesBWinchester
14 жыл бұрын
Excel Magic, I’m having a little trouble with a formula. Wanted to know if, for example any of cells A1-A100 have the word "groceries" in it. I want to take the value in the B column that corresponds to it, and add it in another cell.
@aitchk
11 жыл бұрын
MrExcel. Really appreciate all work you did for us who want to make a living and feed our children using Excel :-) Can you point to some site or tutorials that cover IF logic that can conditionally evaluate the length of text in a cell? (I have a problem where in two adjacent cells (same row) there can be a combination of 5,6, 7, or 8 digit numbers but only certain combinations are acceptable. eg. 5 or 6 digits in first cell AND 8 digits in second, etc. Many combinations must be eval.) thnx!
@jonjon72886
13 жыл бұрын
How do I write a command which will say the following. If a cell is greater than zero move down one row, if not delete row.
@munmunmonty
14 жыл бұрын
@ExcelIsFun - can't we do it with "vlookup" rather "if"?
@moshemeister4610
4 жыл бұрын
where dio i find the worksheets to follow along
@leftylee527
13 жыл бұрын
I could use your help. I'm trying to figure out the IF formula for the following scenario: IF we receive any quantity under the quantity we ordered from a supplier, the supplier scores a "1". IF we receive the exact quantity we ordered up to and including 10% over, the supplier scores a "100". If we receive 11% and over the quantity we ordered, the supplier scores a "1". How would I write up this IF formula? Thanks for any help you can provide.
@Smurfette6891
8 жыл бұрын
Hi! I got lost at the last 2 examples... How is A40 linked with B41, please ? Thanks!
@excelisfun
13 жыл бұрын
I do not know how to do that. But no worries. THE best Excel site for asking questions is: mrexcel[dot]com/forum
@leftylee527
13 жыл бұрын
I need help. I'm trying to figure out the IF formula for the following: IF we receive any quantity under the quantity we ordered from a supplier, the supplier scores a "1". IF we receive the exact quantity we ordered up to and including 10% over, the supplier scores a "100". If we receive 11% and over the quantity we ordered, the supplier scores a "1". How would I write up this IF formula? Thanks for any help you can provide.
@nikhilkhandelwal0311
13 жыл бұрын
@ExcelIsFun please give formula for this condition
@ringong4506
11 жыл бұрын
thank for share
@edwindrg
15 жыл бұрын
Can this logical test work with text. I mean, if F2 = "Ed" then 0 if false then 1. I have only seen it work with numerical values but not text. I know is a logical text and it doesn't disqualify text filled cells. Please, if you can let me know if it does work with text also. Thanks!
@GennyOnTheGo
13 жыл бұрын
I am still confused trying to calculate IF function.Any student worker who works 18 hours or less will have the pay applied to his or her tuition. If a student works more than 18 hrs (referenced in F7), then student will receive a paycheck for hours over 18. In cell D11, construct an IF function to determine the number of hours worked that will be applied to the student’s tuition using cell F7 as an absolute reference. Cell F6 Hourly Rate=$9.75,F7=18. Cell C11: 18,39,22,16,27,20,32,16,11,47,54
@udanial
14 жыл бұрын
sir there is any if use advance videos?
@fantabulous008
14 жыл бұрын
SWEET!!!
@ScorpionJay100
12 жыл бұрын
You are a legend!
@jords23ification
12 жыл бұрын
what command you do in the cell of average?? is that a advance filter? how?
@JamesBWinchester
14 жыл бұрын
Sorry I probably should have explained it a little better. I'm trying to track my monthly spending and i want something that will add up everytime i spend money in say the grocerys category. A1 though A100 have a dropdown menu with different category's. i.e. groceries, dining out, entertainment. column B has the amount I spent in each. looking for something that will search A1 through A100 for the word grocerys and only total the amount to the right in column B, and put the result in say H23.
@alwayzsic
14 жыл бұрын
can you explain the formula on A40? I dont get it.
@leftylee527
13 жыл бұрын
Thank you but it isn't working. In my spreadsheet O2 = Qty Ordered and P2 = Qty Received; so my formula is =IF(AND(P2>=O2,P2
@aman1245singh
14 жыл бұрын
Hello sir, regarding one of the part of this video(put 1 or 2 ranges in a cell), I have used this formula( at the end) to give me sum when A47 is sum and average when A47 is average, and it automatically selects the data1 or data2 depending on what's there in the B48 cell. would you suggest any improvement to this formula. =IF(A47="sum",SUM(IF(B48="Data2",B45:B46,A45:A46)),AVERAGE(IF(B48="Data2",B45:B46,A45:A46)))
@jgbalboa
11 жыл бұрын
You need to use the AND function. =IF(AND(H78>0.36,H78
Пікірлер: 131