| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Idiot Needs Formula Help!! | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
