View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ian Grega Ian Grega is offline
external usenet poster
 
Posts: 39
Default Set a range of cells for ROUNDUP

Use the Int function or roundup, rounddown functions for a single cell. Not
sure what you are doing with a range of cells, summing them?

Your range of B88:B88 is only a single cell. eg =Int(B88)

"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question, but...

I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks