Hi there,
How do I round a number up to the nearest even integer?
ex:
2.54 --> 4
1.27 --> 2
3.91 --> 4
Anything with a decimal gets rounded up.
Thank you for your help,
Rhyder
Hi there,
How do I round a number up to the nearest even integer?
ex:
2.54 --> 4
1.27 --> 2
3.91 --> 4
Anything with a decimal gets rounded up.
Thank you for your help,
Rhyder
Rhyder,
Give this a try:
=CEILING(A1,2)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
perfect - thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks