Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF function to allocate a membership fee

Topic Labels: Formulas
792 0
cancel
Showing results for 
Search instead for 
Did you mean: 
EYES_Internatio
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