Ben SmithBen Smith
Ben Smith/
Tuition Calculator
Tuition Calculator
Tuition Calculator

Tuition Calculator

For
splinterwatsup
From
Reddit
Status
Updating
Formulas
+
+
/
/
empty
empty
if
if
>
>
-
-
toNumber
toNumber
Share

Company Pays

if(prop("Tuition Amount") > 2000, 2000 + (prop("Tuition Amount") - 2000 - if(prop("Tuition Amount") > 8000, prop("Tuition Amount") - 8000, 0)) / 2, prop("Tuition Amount"))

Employee Pays

if(empty(prop("Tuition Amount")), toNumber(""), prop("Tuition Amount") - prop("Company Pays"))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
 
Request Details
  • We will pay 100% of tuition to the value of $2000.
  • If the tuition is over $2000 we will pay 50% of the tuition above $2000. For example, if the tuition is $2500 - $2000 (we pay 100% up to $2000) = $500 Remaining. We will pay 50% of the remaining $500 = $250 left for the employee to pay.
  • We will pay a total of $5000 cost to the company. $5000 is the most we will pay. In other words, if the employee wants to study an $8500 course, we will pay $2000 at 100%, 50% of the next $6000 and the remaining $500 will be paid by the employee. This means we would pay $5000 and the employee would pay $3500.