Formula for incremental increase
jahoobob Wrote: if the # of products is in A1, then place this formula where you want points: =IF(INT(A1/3000)5,INT(A1/3000),5) Thank you for the suggestion, but Excel does not like the first 5 in the formula - it always proposes correcting the formula by multiplying. I also tried to put a comma after the first set of parenthesis but then I get a to many arguments for this function error. Please advise. Thanks in advance! -- alexrm |
alexrm Wrote: Thank you for the suggestion, but Excel does not like the first 5 in the formula - it always proposes correcting the formula by multiplying. I also tried to put a comma after the first set of parenthesis but then I get a to many arguments for this function error. Please advise. Thanks in advance! I don't know what happens on this board. It doesn't like fromulae. Before the first 5, place a less than sign (shifted comma) -- jahoobob |
All times are GMT +1. The time now is 11:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com