I currently have a formula that calculates the cost of a child attending a class over a number of weeks.
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
Solved! Go to Solution.