• Facebook
  • Twitter
  • YouTube
  • LinkedIn

TECH TEACHERS

A Collaborative Site for CAT and IT Teachers

  • Home
  • About
    • About Tech Teachers
    • About Matthew Hains
    • Donate to Tech Teachers
  • Teacher Resources
  • Buy stuff!
    • Digital Classroom Resource
    • View the Store
    • Account
    • My orders
    • Checkout
  • Contact
  • 0 items
Homenested if

nested if

Excel

Rock Paper Scissors – Excel style

Jan 11, 2018Matthew Hains

While I’ve been working on the various Excel activities, I designed a Rock Paper Scissors game in Excel to show how to use nested IFs. It is quite useful to teach logical structure, If-Then-Else statements […]

Information Technology

Delphi activity – perimeter fencing application

Nov 16, 2015Matthew Hains

This program calculates the perimeter of an area after the user inputs two measurements (length and width). It works out the cost per meter and also any applicable price reductions and discounts based on certain criteria. […]

CAT

Excel Functions ~ Text manipulation, Nested IFs and VLOOKUP

May 26, 2014Matthew Hains

How to use Microsoft Excel functions that include Nested IFs, VLOOKUP, LEN, FIND, LEFT, RIGHT, MID, &, LEN, UPPER […]

CAT

Excel Functions ~ Nested IF and VLOOKUP Example

May 19, 2014Matthew Hains

How to use a nested IF and VLOOKUP in Microsoft Excel […]

CAT

Excel Functions ~ Text manipulation

May 12, 2014Matthew Hains

How to use Microsoft Excel functions to manipulate text like LEN, FIND, LEFT, RIGHT, MID, &, UPPER […]

Stay connected

  • Facebook
  • Twitter
  • YouTube
  • LinkedIn

Categories

  • Matthew's Blog
  • Claire's Blog
  • Microbit tutorials
  • Guest Blogs
  • Check this out
  • CAT
  • ICT
  • Information Technology
  • Word of the Week
  • Excel
  • Excel Functions
  • P.A.T.
  • PowerPoint
  • Courses & Training
  • OneNote
  • Little Bytes
  • Delphi
  • Posters
  • Videos
  • StudyOpps Module Tests
  • Tech-Time
  • Successful teacher
  • Microbit Coding (Series)
  • Blogging Course (series)
  • HTML
  • Resources
  • Programming
  • Delphi Training Videos
  • SQL
  • Python
  • Testimonials
  • Spotlight
  • T’s & C’s
  • Shop T’s & C’s

© Matthew Hains