View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Assuming, based on your example, that you want to round *up* to the
nearest even number, one way:

=CEILING(72.5/3,2)

In article ,
Wind54Surfer wrote:

I need to round numbers as part of a formula and can't figure it out.

Say I have 72.5 and need to divide it into 3

I get 24.16 (then I need to round 24.6 to the next even number = 26)

(Anything over an even must go to the next even.)

Any ideas really appreciated.