how to correct the decimal number to the nearest even number

S

santosh kutre

What is the formula to correct the decimal number to the nearest even (not
odd number)number
 
S

shg

=INT(A1) + ISODD(A1)
=MROUND(A1, 2)
Click to expand...
If A1<0, the first formula returns an odd number and the second return
#NUM!

If your data includes negative numbers, you could use either

=INT(A1) + ISODD(INT(A1))

=MROUND(A1, 2*SIGN(A1))

MROUND requires the Analysis ToolPak add-in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd and even header and footers with section break 2
How to count the numbers in a Word document? 0
Excel does not accept text format! 0
Custom Number sequences 0
How to Create an S-Curve from Custom Field? 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
rounding a number up to a certain ending digit 6
Paragraph numbering in Word 1

Top