IF function to allocate a membership fee

Topic Labels: Formulas
616 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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

0 Replies 0