View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Rounding up based on a decimal value

add 0.3, and rounddown
23.6 would be 23.9 - 23
23.7 would be 24.0 - 24
23.8 would be 24.1 - 24

so if values in a2,a3 etc b2=rounddown(a2+0.3)

Steve

On Mon, 27 Nov 2006 16:55:02 -0000, Kelley
wrote:

I would like to be able to round a number based on a decimal value. For
example, if the result is 23.7, 23.8, or 23.9, I want the number to
round up
to 24. I always want to round up for .7 and higher.
Is there a way to code this?