Excel Magic Trick #31 Part 2: IF AND OR functions, logical
September 9, 2009 - 1:30 am
See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the cell contains text!
See how to make the labels on your Income Statement change depending on whether or not there is a Net Loss or a Net Income. See how to use the IF, AND, and OR function to evaluate a customer’s credit.
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel Magic Trick 167p2 IF function formula: 12 Examples!
Duration : 0:7:39
[youtube 8909J9d71j0]
September 9th, 2009 at 1:30 am
Dear salongirl77,
…
Dear salongirl77,
Life is like a boomearng!
–ExcelIsFun
September 9th, 2009 at 1:30 am
Dear microsuez,
…
Dear microsuez,
I total agree!!!! And obviously, the Federal Reserve needs to learn about this also!
–ExcelIsFun
September 9th, 2009 at 1:30 am
Lehman Brothers …
Lehman Brothers should watch your video to learn the tricks of IF, AND, OR in extending credits to their customers !
September 9th, 2009 at 1:30 am
sorri, this was far …
maybe if you speak a bit slower or something it may be easier to follow. Was able to pick up this fucntion off another video on here. Gd try anyway. Cheers
sorri, this was far too complicated
September 9th, 2009 at 1:30 am
Dear shiryu008,
…
Dear shiryu008,
No problem!!
–ExcelIsFun
September 9th, 2009 at 1:30 am
the secret of blank …
the secret of blank is “”. Man, it so simple that i couldn’t think on it yet before. sometimes you have the ansewer in front of you but you look for complications!!. Thanks excellsfun.
September 9th, 2009 at 1:30 am
thank you, i will
thank you, i will
September 9th, 2009 at 1:30 am
Dear sbuulo,
…
Dear sbuulo,
Don’t be sorry - please help me find all my mistakes!!! As for being good at Excel, just keep learn a few new things each day and you will get much better!!!
–ExcelIsFun
September 9th, 2009 at 1:30 am
Dear ExcellsFun,
…
Dear ExcellsFun,
Sorry I never knew that is been spotted be4, and my apologise for that, any way you are doing great job, and I personally have learnt allot, I only wished that I was as good as you are with Excel, as I am an accountant and your knowledge makes my life already easy.
September 9th, 2009 at 1:30 am
Dear sbuulo ,
…
Dear sbuulo ,
Thank you for finding my mistake!! However, tuan1765 found this mistake about 4 months ago. If you watch the Video Response that I posted I addressed this mistake.
Man, it would be great if we could add deductions from our bank accounts!! With all the Debt Trouble in America, it seems like that is what we dumb debt-ridden Americans have been doing for the last 20 years!!!
Keep watching and please keep me on my toes!!
–ExcelIsFun
September 9th, 2009 at 1:30 am
ACCIDENTAL MISTAKE …
ACCIDENTAL MISTAKE SPOTTED
Excel Magic Trick #31 Part 2: IF AND OR functions, logical
I though withdraw meant (-) subtracting from the us$500 (500-20) and deposit should have been (+) (480-50), let me know if i misunderstood you, I live in UK so maybe in America you do things this way IN YOUR BOOK REGISTERS, either way you are doing great job, and this was simple mistake, and I am thankful with your free classes. I have learnt allot your excel formulas.
September 9th, 2009 at 1:30 am
Dear eiledon7,
…
Dear eiledon7,
You are welcome!!! I’ll keep making them, if you keep watching and rating!!
–ExcelIsFun
September 9th, 2009 at 1:30 am
Thank you so much …
Thank you so much for these!
September 9th, 2009 at 1:30 am
Dear lennydw67,
…
Dear lennydw67,
It took me a few weeks, but I just posted a video on Solver. See video:
YouTubersLoveExcel#21: Solver for Linear Algebra
–ExcelIsFun
September 9th, 2009 at 1:30 am
Dear lennydw67,
…
Dear lennydw67,
Yes, but…
It will be at least a week. I have about 20 other videos already in the works. Also, when I post a video about Solver, because I only know a little bit about linear algebra and a little bit about Solver, it will not be as comprehensive as some of the other videos that I post. Nevertheless, I have a few tricks for Solver too…
–ExcelIsFun
September 9th, 2009 at 1:30 am
Thanks for this…. …
Thanks for this…..can u post something on using Solver?
September 9th, 2009 at 1:30 am
Dear fatisaway,
…
Dear fatisaway,
See the 2 videos that I made for you:
1) You Tubers Love Excel 2007#3: SUM across sheets
2) YouTubers Love Excel 2007 #4: Count Unique Records
Let me know if these answer your question.
For future questions, explain question & problem completely and send me a workbook example by e-mail. That way I can get my answer exactly right!
-ExcelIsFun
September 9th, 2009 at 1:30 am
Hi, thanks so much …
Hi, thanks so much for the videos, they proved to be quite helpful. I tend to work with tabs in workbooks and it would be quite helpful if you could show me how to sum particular items in different tabs to save time, also say in a row there are names of companies or so, and they repeat, how could you count how many companies are there to avoid counting the same ones several times.
Thanks a lot
September 9th, 2009 at 1:30 am
Dear tuan1765,
…
Dear tuan1765,
Thanks pointing that out! Yes, I wish that every time I withdrew money from my bank I could have my balance go up! Hey the correct formula for calculating the checkbook balance in cell G18 is =IF(D18=”",”",G17-E18+F18). Then you copy that down. The balance calculation is always: (Balance from above) - Withdrawals + Deposits. I guess when I get going on the video sometimes I can’t see my own mistakes.
Hey, send me Excel questions - I’ll make videos to answer!
-Mike Gel
September 9th, 2009 at 1:30 am
Your formula for …
Your formula for the balance was incorrect, but no big deal. Your videos are very helpful. Thanks so much!