Excel Lezione 8: la funzione SE spiegata attraverso 9 esempi. Non esiste Excel senza il SE!!

A donation? It only takes a few cents... https://www.paypal.com/donate/?busine... Let's learn how to use the IF function to perform calculations, write text, and formatting as cell contents vary. 9 exercises will help us understand how it works and in which situations it can be useful to use it. 00:00 Theory of the IF function 03:46 Exercise 1 - University exam 07:07 Conditional formatting Exercise 1 09:09 Exercise 2 - Redoing/Not redoing a class assignment 10:51 Exercise 3 - Hotel near/far from the city center? 12:46 Exercise 4 - Refund? 3:27 PM Exercise 5 - Choose gender from the drop-down menu (with error message) 6:49 PM Exercise 6 - Traffic light with conditional formatting 10:24 PM Exercise 7 - Umbrella or no umbrella? 11:34 PM Exercise 8 - Grade with bonus and final result (2 formulas with "if") 10:25 PM Exercise 9 - Bill with discount (Yes/No) and total to be paid.