In so many real world spreadsheets you need have the spreadsheet choose a formula to use based on some criteria of the data. The IF function is a basic tool you will need to understand to do this.
Index to my other excel videos: https://teklern.blogspot.com/p/excel-...