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.
![Screenshot 2022-01-20 at 13.04.58 Screenshot 2022-01-20 at 13.04.58](/t5/image/serverpage/image-id/22380iF7100F4A506C87FD/image-size/large?v=v2&px=999)
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