Excel ODD function
The ODD function rounds a number up to the nearest odd integer.
- Number (required): A numeric value that you want to round up to the nearest odd integer.
1. The #VALUE! error value occurs if “number” is nonnumeric;
2. This function rounds a number away from zero. After rounding, a positive number becomes larger and a negative number becomes smaller;
3. If a number is an odd integer, it remains unchanged.
It returns an odd integer.
In the table below, there is a list of numbers that you want to round up to the nearest odd integers. You can apply the ODD function as follows to get it done.
1. Select a blank cell (here I select cell C6), enter the formula below and press Enter to get the result. Then drag its AutoFill Handle down to the cells where you want to apply this formula.
1) You can see in the results:
-- If a number is 0, the ODD function rounds to the positive value +1;
-- For an odd integer, the ODD function returns the same value.
2) In cell C6, you can directly type the numeric value in the formula such as:
The Best Office Productivity Tools
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
Please leave your comments in English