Thank you! Sorry for continuing to pester, but another issue came up. (Hopefully this makes sense.) So, this equation we’re using is for members to figure out how much their dues will be per paycheck. With that said, we have a myriad of options for the number of paychecks that workers typically receive (9-52) in a given year. However, there is a monthly dues cap ($80), which means in certain instances, a single weekly paycheck will result higher than that amount using our formula. For example, a person making $200,000 per year under a typical 26 paychecks per year cycle will pay $103.85 per pay check — higher than the monthly cap.
Is there a way, in those instances where a single paycheck is higher than the cap, to have it result in a figure that takes into account the cap and divides it equally per month? Or something of that sort?
Equation can be found here, form field here.
Gotcha! I’m also currently using the PREC decimal limit in the equation. How would I add the MIN aspect to it?
Current eq: PREC(fieldname2*0.0135/fieldname10, 2)
