Parcel Charge Problem
Input the weight of a parcel. Program should determine the delivery charge for that parcel and print it out. (use the following table)
|
Parcel weight (kg) |
Cost per kg($) |
|
< 2.5 kg |
$3.50 per kg |
|
2.5 – 5 kg |
$2.85 per kg |
|
> 5 kg |
$2.45 per kg |
Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdCharge. Place the code under the Click event of a command button titled “Parcel Charge”.
Hint: Use nested If statements in the flowchart and the code.
