Change Player Size
Watch this video in a new window

Microsoft Excel #06: Using "IF" in Formulas

More advanced formula uses including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40." This is a very powerful tip.  
 
Customize

More From: freetutorials

Microsoft Excel #07: Importing Data & Working with Graphs8:26
Microsoft Excel #07: Importing Data & Working w...
51,530 views
Microsoft Excel #05: Tips, Tricks, & Form Creation4:54
Microsoft Excel #05: Tips, Tricks, & Form Creation
152,630 views
Microsoft Excel #02: Create a Seating Chart8:26
Microsoft Excel #02: Create a Seating Chart
81,903 views
Excel - Back to the Basics: Formulas and Formatting 28:52
Excel - Back to the Basics: Formulas and Format...
29,564 views
Photoshop Tips: Replace Colors!4:31
Photoshop Tips: Replace Colors!
44,612 views
Excel - Back to the Basics: Formulas and Formatting9:39
Excel - Back to the Basics: Formulas and Format...
25,056 views
Microsoft Excel #04: Excel as a Database4:19
Microsoft Excel #04: Excel as a Database
164,873 views
Adobe Flash CS3 Professional: Classroom in a Book: Chapter 415:35
Adobe Flash CS3 Professional: Classroom in a Bo...
8,108 views
Adobe Flash CS3 Graphics: The Illusion of 3D6:07
Adobe Flash CS3 Graphics: The Illusion of 3D
2,232 views
Adobe Flash CS3: Classroom in a Book Chapter 321:41
Adobe Flash CS3: Classroom in a Book Chapter 3
1,347 views
Web Page Design: Finding HTML Errors / Validating6:03
Web Page Design: Finding HTML Errors / Validating
576 views
Adobe Flash CS3: Working With Graphics26:02
Adobe Flash CS3: Working With Graphics
1,127 views
FTP: Finding, downloading, and using an FTP client7:09
FTP: Finding, downloading, and using an FTP client
16,021 views
XHTML Tips & Tricks: CSS Buttons9:46
XHTML Tips & Tricks: CSS Buttons
5,060 views
Web Page Design: A Case Study (Part 3)7:21
Web Page Design: A Case Study (Part 3)
4,843 views
Web Page Design: A Case Study (Part 2)10:18
Web Page Design: A Case Study (Part 2)
1,500 views
Web Page Design: A Case Study (Part 1)15:34
Web Page Design: A Case Study (Part 1)
5,775 views
ImageMaps with Front Page11:40
ImageMaps with Front Page
1,402 views
Web Page Design (Part I): Visual Elements8:51
Web Page Design (Part I): Visual Elements
5,759 views
CSS Part 5 (of 5): Validating Your CSS Code3:36
CSS Part 5 (of 5): Validating Your CSS Code
2,818 views
See all 117 videos
Play All Stop Autoplaying | Play Next

QuickList(0)

1
Clear | Save

Related Videos

Featured Videos

Upgrade to Flash Player 10 for improved playback performance. Upgrade Now or get more info.
This is a video response to Microsoft Excel #01: Introduction to Excel
38 ratings
Sign in to rate
84,170 views
Flag
close
Want to add to Favorites? Sign In or Sign Up now!
close
Want to add to Playlists? Sign In or Sign Up now!
close
Want to flag a video? Sign In or Sign Up now!

Statistics & Data

Loading...
Sign in to post a Video Response

Video Responses (0)

This video has no Responses. Be the first to Post a Video Response.
Sign in to post a Comment

Text Comments (45)   Options

Loading...
krn14242 (1 week ago) Show Hide
 0
Marked as spam
go to excelsfun, much better channel.
hasina21 (3 weeks ago) Show Hide
 0
Marked as spam
Hi, I am looking to validate UK Postal Code using IF formula in MS Excel, can you be any help!!! The postal code is should be in the following format:

AN NAA
ANN NAA
AAN NAA
ANA NAA
AANA NAA
AANN NAA

When A is alphabet and N is number. If the condition is incorrect then highlight that particular cell that contains the incorrect postcode.
Many thanks in advance.
Mumlor (1 month ago) Show Hide
 0
Marked as spam
Can you have more than one condition in an "IF" formula? For instance =if(condition 1 AND condition 2,Yes,No). Also can you combine an "IF" and a "COUNTIF" in the same formula? So, =if( A1:A50=Flowers AND B1:B50=Roses,countif(C1:C50,"R ed")).
thuynguyenable (4 weeks ago) Show Hide
 0
Marked as spam
Reply
No, in this case, you just need to use COUNTIFS if you have more than 1 conditon to count your item. Excell have both Countif (for one condition to count) & and Countifs ( used to count item that has more than 1 criteria)
sweetiecb (4 months ago) Show Hide
+5
Marked as spam
Great info however even if I click on the HQ button it doesn't change it at all.. and it's still not only small but very blury. is there something the teacher can do when making the video to make it larger and clearer. There is another guy doing excel tutoring and his is clear and at times he zooms in a bit to make it easier to see.
Thanks for your help
MyTwig (4 months ago) Show Hide
 0
Marked as spam
yes it would be clear.
bernardolea (5 months ago) Show Hide
+2
Marked as spam
it would be a great help if you can maximize it cause i can't see it clearly,...
johnniegeeee (5 months ago) Show Hide
 -2
Marked as spam
Just click on the HQ button. shows up clearly for me
yaydaphne (5 months ago) Show Hide
 0
Marked as spam
Your tutorials are really useful! Helped me a lot in my schoolwork! :D Thank you very much!
Penguinz13989 (7 months ago) Show Hide
 0
Marked as spam
hq, i can see fine

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.