# Excel ODD Function

Summary

The Excel ODD function returns the next odd integer after rounding a given number up. The ODD function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative).

Purpose

Round a number up to the next odd integer

Return value

A rounded number.

Syntax

=ODD (number)

Arguments

**number**- The number to round up to an odd integer.

Usage notes

The ODD function always rounds up to the next odd integer, skipping even integers along the way.

Note if you are using ODD with negative numbers, values are rounded away from zero, so they actually become more negative.

Good links

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.