We are membership based organization. We currently are implementing a new membership fee structure based on how old the member is:
<20= 250 €
20-25 = 500€
26-30 = 800€
31-34 = 1.200€
35 = 1.200€
(older and equal to) 40 = 500 €
I have all the members “ages” but would like to create a column next to it with a function that will automatically calculate what membership fee they are with that age.
Is there someone who can help with this?
I have tried different things I found online through forums and youtube but im struggling to make it work.
Thanks so much in advance