Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Dec 14, 2020 08:59 AM
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
Solved! Go to Solution.
Dec 14, 2020 09:14 AM
It sounds like your formula would be:
{Extrachildren} * MIN(({Weeks FM}+{WeeksSR}), 10) * 5
^ The MIN()
function means no number higher than 10 will be multiplied.
Dec 14, 2020 09:14 AM
It sounds like your formula would be:
{Extrachildren} * MIN(({Weeks FM}+{WeeksSR}), 10) * 5
^ The MIN()
function means no number higher than 10 will be multiplied.
Dec 14, 2020 09:31 AM
Hi Kamille
Perfect answer.
It always seems so obvious after I see the solution.
I do hope someday I will understand formula.
Many thanks
Phil