Help

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

Amend a Formula to cater for a discount

Topic Labels: Formulas
Solved
Jump to Solution
297 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.

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