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
|