View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terri Terri is offline
external usenet poster
 
Posts: 110
Default Need to cap a sum

This may be very basic, but I have a column that I need to sum, but if the
total is over 1000, it only shows 1000. Any clues as to how to accomplish
this?