I am trying to set up Airtable to have an interface where my office staff can get the amounts they need for a meal plan change.
We have multiple plans and each week the cost of the plan reduces by a set amount until the end of the change period. The amount reduced is different for each plan. When someone wants to change their plan we take the prorated amount of the original plan and deduct the prorated amount of the new plan. If the amount is positive then the customer is given a refund, but if the amount is negative the customer is charged the additional fee. In either case, there is a set fee for the change. If they want to cancel the prorated amount of the plan, plus the remaining balance of their point plan, minus the fee is calculated so it can be refunded. There are some cases where the fee would not be applied.
My goal is to have an interface my staff can use to choose the current plan then choose the new plan and the interface would tell them how much needs to be charged or refunded since it would already be accounting for the proration and such.
I appreciate any and all help. Formulas are not my strong suit in the least.
Thank you