Excel 2000 in a Nutshell

Name

ODD

Synopsis

Use ODD to round a numeric value to the closest odd integer. This function rounds away from zero, meaning that if the numeric value is greater than zero it rounds up, whereas if the value is less than zero it rounds down.

To Calculate

=ODD(Number)

Number

This required argument must be a numeric value that you want to round.

Example

Figure 14-7 illustrates the difference in the results returned by EVEN and ODD. Notice that when ODD receives a negative value it is rounded down (away from zero) to the next even integer. For example, -4.2 is rounded to -5.