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 […]
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. […]
How to use Microsoft Excel functions that include Nested IFs, VLOOKUP, LEN, FIND, LEFT, RIGHT, MID, &, LEN, UPPER […]
How to use a nested IF and VLOOKUP in Microsoft Excel […]
How to use Microsoft Excel functions to manipulate text like LEN, FIND, LEFT, RIGHT, MID, &, UPPER […]
© Matthew Hains