Forum Discussion
Solved
Even numbers Roundup
Hey everyone, I have around thousands rows of data in excel and I want to do numbers to nearest even round. For instance, I have 2.05, 2.15, 2.25, 2.35, 2.45, 2.55, 2.65, 2.75, 2.85 and 2.95 numbers I want to round them to 2.05 to 2.09, 2.15 to 2.29 and 2.25 to 2.29, 2.35 to 2.49 and 2.45 to 2.49 like even numbers in excel. So how can I do that?
Thank you.
Does this do what you want?
Let's say the numbers are in A2 and down.
Enter the following formula in B2, then fill down:
=CEILING(A2-0.09,0.2)+0.09
11 Replies
Does this do what you want?
Let's say the numbers are in A2 and down.
Enter the following formula in B2, then fill down:
=CEILING(A2-0.09,0.2)+0.09
- Thanks for reply, it's working. However, what if I need 1.75 to 1.99, 1.85 to 1.99 and 1.95 to 1.99. Do not need 1.89. after 1.69 I need 1.99. so is it possible?
Please provide some more examples.
