Hello

I am hoping someone can help me?

How can I create an if formula that takes the number of years since client was onboarded (we have this as field already I.e  years since since onboard) and the starting cost for client to then is multiply this cost by 5% for each year since being onboarded?

In some cases clients have a fixed cost for a period e.g 3 years (this is captured in another field) can we therefore build this into the formula to only at the 5% to starting cost after the fixed period has lapsed?

Thanks