I need to Enter a formula that will generate the daily discount amount. This will test if a person qualifies for a discount. If not the amount should be 0.
In Cell D6:The attendance is 4 days/week.
In Cell F6:The daily fee is 48
In Cell B56: The discount is 10%