Discount Price Problem |
|
Input the original price value and discount rate value, use a procedure to calculate the discount price by multiplying the original price by the discount rate to get the discount amount, then subtract this from the original price to get the discount price. Use original price value and discount rate value as arguments for the procedure . Name the procedure DiscountPrice. Display “Discount Price” label and its numeric value as outputs.
Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdDiscountPrice. Place the code under the Click event of a command button titled “Discount Price”. |
![]()
|
![]() |