Thread: Round to nearest whole number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve C Steve C is offline
external usenet poster
  
Posts: 119
Default Round to nearest whole number
Upon dividing one cell by another, I want to store the result in a variable
that is rounded to the nearest whole number (6.5 = 7, 6.2 = 6, etc.).

My basic formula is:
NamesPerSlip = ActiveCell.Offset(0, -3) / ActiveCell.Offset(0, -2)

Rounding NamesPerSlip up or down as needed is my challenge. Thanks as always!

--
Steve C
Reply With QuoteReply With Quote