Jun 08 2022 12:12 PM
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.
Jun 08 2022 12:20 PM
SolutionDoes 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
Jun 08 2022 12:30 PM
Jun 08 2022 01:35 PM
Jun 08 2022 02:20 PM