| A | B | C | D | E | F | G | H | I | J | K | L | |
| 1 | Cost per Exam | 10 | ||||||||||
| 2 | Reduction for under 18 | 40% | Constant Input data | Reduction | =IF(F6<=18,I6*$B$2,0) | |||||||
| 3 | Tuition Cost per module | £20.00 | If person < 18, multiply Exam Cost x 40% (Reduction), OTHERWISE 0 | |||||||||
| 4 | ||||||||||||
| 5 | First Name | Surname | Address1 | Address2 | Phone | Age | Module Name | Tuition Cost =$B$3 | Exam Cost =$B$1 |
Reduction | Net Exam Cost =I6-J6 |
Total Cost =H6+K6 |
| 6 | Adam | Apple | Kilmallock | Co. Limeri | 15 | Module1 | € 20.00 | € 10.00 | € 4.00 | € 6.00 | € 26.00 | |
| 7 | Bertie | Bruton | Kildare | Co. Kildare | 17 | Module1 | € 20.00 | € 10.00 | € 4.00 | € 6.00 | € 26.00 | |
| 8 | Con | Carr | Henry St | Limerick | 25 | Module1 | € 20.00 | € 10.00 | € 0.00 | € 10.00 | € 30.00 | |
| 9 | ||||||||||||
| 10 | ||||||||||||
| 11 | Sample variable input data | Sample output data | ||||||||||
| 12 | ||||||||||||
| Other possibilities that could be explored as possible projects | ||||||||||||
| 1 | Club members and costs of joining Club | |||||||||||
| 2 | Tour company users and costs of travelling | |||||||||||
| 3 | Products and product costs (Cost price,Mark up,Sale price) | |||||||||||
| 4 | Invoice with sample Products | |||||||||||
| 5 | Employee wage calculations (commission on sales or overtime rates) | |||||||||||
| 6 | Anything else you can think of provided it meets the guidelines | |||||||||||
| Finally it can BE DONE | ||||||||||||