IF function to allocate a membership fee

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.