ExcelBanter - Formula for incremental increase

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula for incremental increase (https://www.excelbanter.com/excel-worksheet-functions/49344-formula-incremental-increase.html)

alexrm

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

jahoobob

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

All times are GMT +1. The time now is 02:43 AM.