View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jlatenight jlatenight is offline
external usenet poster
 
Posts: 2
Default 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