Limit a calculation to a certain number
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
|