Microsoft Excel 2021365 - Beginner to Advanced - Making Decisions with IF Statements

This video tutorial explores the use of logical functions in Excel, focusing on the IF function. It provides a detailed example of calculating shipping charges based on total cost using the IF formula. The tutorial guides viewers through constructing the formula, ensuring correct formatting, and completing the table with total cost and shipping calculations. It also introduces advanced concepts like nested IFs and other related formulas, encouraging further learning in an intermediate course.

Explain how to lock a cell reference in a formula.

What are nested IFs and how do they differ from a simple IF function?