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