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.