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.

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(A12,A1*75-75,if A1=2,75,A1*25))

"Nic" wrote:

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.

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

"Nic" wrote in message
...
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.

=((MATCH(A14,{0,1,2,3})-1)*25)*A14
--
Don Guillett
SalesAid Software

"Nic" wrote in message
...
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.

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

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

Cheers

"Don Guillett" wrote:


=((MATCH(A14,{0,1,2,3})-1)*25)*A14
--
Don Guillett
SalesAid Software

"Nic" wrote in message
...
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.

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

--
Don Guillett
SalesAid Software

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

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

Cheers

"Don Guillett" wrote:


=((MATCH(A14,{0,1,2,3})-1)*25)*A14
--
Don Guillett
SalesAid Software

"Nic" wrote in message
...
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.