View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bro40dz Bro40dz is offline
external usenet poster
 
Posts: 1
Default formula to round up any number less than 35 upto 35.

im currently working on a spread sheet and was hoping someone would know a
formula so that when a number is less than 35, it will be automatically
rounded up to 35.
parts of the row have auto sum to total up this number ( being upto, or
actually 35) but i want it to change, for example, 32.4 into 35.
thanks guys