Increasing the number calculated by for same column

[Nic]

I have created a tracking sheet for a rewards program where the weekly sales,
parties held, recruits are all rewarded with different amounts of points.
The column I am having issues with is the recruiting. Points are awarded for
each recruit. However, they vary with how many you get. The first recruit
is 25 points, the second 50 points and the third and above are 75 points
each. I do not know where to start with calculating this. I want to write
in the colomn the number of recruits for that week and have the points
calculated in another column and added to the progressive total column for
that week.

I hope this is not too confusing. Your help is greatly appreciated.

Cheers Nic.

 

[bj]

I am not a hundred percent sure what you want but if the number of recruits
is in column A
the number of points could be
=if(A1>2,A1*75-75,if A1=2,75,A1*25))

 

[Don Guillett]

If I understand your desires try
=(MATCH(A14,{0,1,2,3})-1)*25

 

[Don Guillett]

=((MATCH(A14,{0,1,2,3})-1)*25)*A14

 

[Nic]

I appreciate all the comments and the super quick responses. I came up with
this and it actually works (hooray for me!!).

=IF(P11>0,IF(P11>=3,((P11-2)*75)+50+25,IF(P11=2,((P11-1)*50)+25,IF(P11=1,25,0))),0)

Cheers

 

[Don Guillett]

I understood you to mean that:
1=25
2=50*2
3=75*3
4=75*4