Lesson 5 – Excel & Data Tables
Intro:A fruit company wants your help with the orders. What you will learn: Primarily Excel Data Tables Secondarily: Condition in an If Variables Client name:Green Fruit Process Name:Fruit Orders Description:Green Fruit wants to have a robot, that automatically can calculate orders: Read the Excel sheet Calculate the Totals column (that is quantity multiplied with price) […]
Intro:
A fruit company wants your help with the orders.
What you will learn:
- Primarily
- Excel
- Data Tables
- Secondarily:
- Condition in an If
- Variables
Client name:
Green Fruit
Process Name:
Fruit Orders
Description:
Green Fruit wants to have a robot, that automatically can calculate orders:
- Read the Excel sheet
- Calculate the Totals column (that is quantity multiplied with price)
- Place a "Yes" in the "Big Order" column, if the Total is bigger than 10