Try this:

=MIN(ROUNDDOWN(C17/10,0),1000)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"jlatenight" wrote:

Here's what I have for a formuls for a cell: =ROUNDDOWN((C17/10),0) I
want to take the answer for that (which happens to be 1051) and say
"limit the answer to 1000". In other words, for that column, I want
the maximum answer returned to be 1000. Can't be more than that, but
it can be under. How would I do that?? Thanks all!
-Jon