Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need help rounding numbers, please.
Hi everyone,
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. Thanks, Emilio |
#2
|
|||
|
|||
What if the result is odd?
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
=ROUNDUP(A16/2,0)*2
-- HTH RP (remove nothere from the email address if mailing direct) "Wind54Surfer" wrote in message ... Hi everyone, 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. Thanks, Emilio |
#5
|
|||
|
|||
Hi
With your number p.e. in A2 =ROUNDUP(A2/(3*2),0)*2 Arvi Laanemets "Wind54Surfer" wrote in message ... Hi everyone, 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. Thanks, Emilio |
#6
|
|||
|
|||
Thanks a lot to everybody.
I am impress how many people are willing to help. Thanks again, Emilio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Rounding numbers in charts | Excel Discussion (Misc queries) | |||
Rounding Numbers | Excel Worksheet Functions | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |