I currently have a formula that calculates the cost of a child attending a class over a number of weeks.
Extrachildren*({Weeks FM}+{WeeksSR})*5
This works well until I was told if they book for 11 weeks then the 11th week is free (they never book for more than 11).
So I need the formula to multiply by 10 if 11 weeks are booked.
Can somebody please tell me how that should be expressed in the formula.
Thanks in advance
Phil