Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Excel 2010 Expert 3
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

This is the third class in our Excel 2010 Expert Series. It picks up where Expert Level 2 left off. The focus of this course is working with logic functions in Excel. Topics covered include:

- Understanding logic (boolean) values
- True, False, And, Or, Not
- Using the IF function to make decisions
- Nested IF functions for multiple options
- Calculating sales tax IF customer is in-state
- Assigning a pass/fail grade to a student
- Giving a student a letter grade (A-F)
- Time sheet calculations that cross midnight
- Is a given cell blank, text, number, etc.

Late Criteria Upload Images   Link 
Jonathan Singer 
5 years ago
If the criteria to collect is to be late shouldn't it be "NOT D2" as well?

Reply from Alex Hedley:

Collect is for a Collection letter to be sent.
Paid (C) has to be FALSE
Late (D) has to be TRUE
Add a Reply
Guys Where do I find the instructions to change o Upload Images   Link 
Chris Daniggelis 
6 years ago
Where do I find the instructions to change or highlight a cell with a color if certain conditions exist
Thank You

Reply from Alex Hedley:

Conditional Formatting
Add a Reply
homework assignments Upload Images   Link 
Simplice Ziriga 
7 years ago
I dont think you have to see things in term of comments we make on course or not. If I dont make a comment or take a survey do not mean necessary I dont like the way you teach. Just do what you have to do to help us master the course. THANKS
Add a Reply
homework assignments Upload Images   Link 
7 years ago
The courses are understable but if we dont use the concept by practicing with some homeworks following each course, we will lose the concept we learned.
We need practicing to emphasize the concepts. Complete the courses with homeworks. That will be great! Read More...
Add a Reply
calculating commissions Upload Images   Link 
tarek mounayar 
7 years ago
Hi Richard, I have an agent that gets paid on commission. If he achieves 1M$ he gets 15% of sales, if he achieves between 1M$ and 2M$ he gets 17.5% sales, if he achieves over 2M$ he gets 20% on sales. How do i put that in one formula considering that yearly sales since 2010 has been 1.5M$, 2.2M$ 3.1M$ and 4.4M$? Read More...
Add a Reply
Upload Images   Link 
9 years ago
Excel-Expert Lesson 3: After 5:37 minutes of running the NOT function returned FALSE in cell E3. Is that correct? You said it will negate the AND function always, which is not the case here.
Add a Reply
Upload Images   Link 
┬áSrinath Nandyal 
10 years ago
While discussing whether to send a collection letter or not, you identiifed a row that contained proper arguments in cell D2 (FALSE) and C2(TRUE). It is likely that you can encounter where required arguments are NOT in the same row. If we end up selecting cells from different rows to satisfy the requirement. copying downward would distort the end result. Read More...
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

6/23/2021Import Data
5/14/2021Quick Queries #4
4/4/2021Text to Columns
3/15/2021VLOOKUP in Access
2/17/2021Old Excel 2003 Outlines
2/17/2021Excel Expert Outlines
2/17/2021Excel Beginner Outlines
2/4/2021Free Beginner Courses
12/26/2020Import New, Changed Records
12/13/2020Duplicates Conditional Formatting

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: excel logic true false and or not if  Page Tag: whatsnew  PermaLink