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 More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Excel 2010 Expert 3
By 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.

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

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

Conditional Formatting
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
SIMPLICE ZIRIGA
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!
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\$?
Anonymous
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.