CommencerCommencer gratuitement

Well nested IF functions

Now that some additional categorization regarding shipment information has been added, time to deal with the financial data. As the data provided by DataCo covers different business areas, like Sales and Finance, they have also provided some key notes from each department along with the instructions. You notice that the Finance department must handle any cash payment of $200 or more differently.

_If you lost progress, close any open reports and load 3_3_well_nested_if.xlsx from the Workbooks folder. If a message appears saying "Security Warning - External Data Connections have been disabled", click on _Enable Content_ and continue._

Cet exercice fait partie du cours

Préparation des données dans Excel

Afficher le cours

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice