Login & Start Learning!

or

VIDEO PLAYLIST

Testimonials

“During my last semester of college, I only knew a little bit of Excel and was in the job hunt for my post grad life. I purchased the student packet from Excel Tutor and learned may more than I ever thought possible about Excel. I am so excited to put all my new Excel knowledge on my resume.”

Patricia H.

“ I’ve been working in the insurance industry for a few years now and have been trying to get my fellow colleagues to understand Excel and perform at a more efficient rate. I found this site and after completing the courses myself, I now have my entire department completing these courses! ”

David P.

“My boss told me that I needed to find a way to be “more efficient and effective” for my daily tasks. That’s when I went hunting for an online Excel course. Excel Tutor was the answer! I learned so many tricks and I even received a promotion in my job last week due to what I learned from this website.”

Phil B.

Logic Functions: Nested If

  • Description
  • Discussion
If you want more than two options for an If function, you are going to have to Nest one IF function within another. I call this “InFunction.” Oftentimes, your analysis may have more than two results and nesting one “IF” function within another “IF” function will allow you get as many different results as you want (well, technically Excel 2010 only allowed up to 64 IFs but do you really need that many “IFS” – there is probably an easier way…)

Support Files:

Logic-Blank.xlsx Logic-Complete.xlsx

Leave a comment

(Your email address will not be published.)

Rate this Video:

Members Also Watched

  • Introduction (2m 4s)

  • Task 5: 6 – 10 (3m 36s)

  • Task 5: 1 – 5 (2m 54s)

Loading...