Microsoft Excel Lesson 6 - If function, nested if function, AND function

Channel:
Australia Magic Monk
Subscribers:
65,900
Published on ● Video Link: https://www.youtube.com/watch?v=X8fslu5bt64


Duration: 12:04
1,400 views
6

In this lesson we talk about 3 more decision making functions in Excel - the IF function, which lets Excel output data based on whether the input condition is true or false, the nested if function (an If function inside another if function), and the AND function, which tests whether 2 or more conditions are both/all true.

Link to Excel Lessons Playlist:
https://www.youtube.com/playlist?list=PLzr5fRV1AGV9CMSWzCjFExhEfzDxZcGFX



Other Videos By Magic Monk


2014-01-04Expert Systems Lesson 1 - Using an expert system
2014-01-04How to test whether 3D works on your 3D TV
2014-01-03Experimental Probability using basketball
2014-01-01Surds lesson 8 - Rationalising denominators using conjugates
2014-01-01Surds lesson 7 - Rationalising the denominator
2014-01-01Surds lesson 6 - Binomial Expansion (Distributive Law)
2013-12-31Surds lesson 5 - Division
2013-12-30Surds lesson 4 - Multiplication
2013-12-30Surds lesson 3 - Addition and subtraction
2013-12-30Surds lesson 2 - Simplifying surds
2013-12-30Microsoft Excel Lesson 6 - If function, nested if function, AND function
2013-12-29Microsoft Excel lesson 5 - count and countif functions
2013-12-28Microsoft Excel lesson 4 - Dice Simulator (randbetween function, paste as values)
2013-12-28Microsoft Excel lesson 2 - compound interest calculator (absolute referencing, fill down)
2013-12-28How to force copy files off scratched dvds
2013-12-26DVD drive missing in Windows 8
2013-12-26How to get data off an old hard drive
2013-12-25How to stop a program from running automatically when computer starts (Windows)
2013-12-25Solution to Christmas puzzle, subscriber winner and prize announced, why does 0 factorial equal 1
2013-12-24How to save your files online - Cloud Storage comparison
2013-12-22Free Android Games - Real Racing 3 tutorial


Tags:
if function
and function
excel if function
excel and function
excel tutorials
excel tutorial
excel if function tutorial
excel and function tutorial