Formula for incremental increase

I am trying to write a formula that will give each cutomer in my file 1
point for every 3,000 of product that they purchase up to 5 total
points. I have tried many variations on IF statments but am unable to
get them correctly recognize each level. Any assistance that anyone
could provide would be greatly appreciated!

-A


--
alexrm

alexrm Wrote:
> I am trying to write a formula that will give each cutomer in my file 1
> point for every 3,000 of product that they purchase up to 5 total
> points. I have tried many variations on IF statments but am unable to
> get them correctly recognize each level. Any assistance that anyone
> could provide would be greatly appreciated!
>
> -A
if the # of products is in A1, then place this formula where you want
points:
=IF(INT(A1/3000)<5,INT(A1/3000),5)


--
jahoobob