ODD

Rounds a number up to the nearest odd integer. Learn more

Video field
Math

In Google Sheets, the ODD() function is used to round a given number up to the nearest odd integer.

The ODD() function takes one argument, which is the number you want to round up to the nearest odd integer.

For example, if you have a value of 7.2, the ODD() function will round it up to the nearest odd integer, which is 9. If you have a value of 3.5, the ODD() function will also round it up to 5, which is the nearest odd integer.

The syntax for using the ODD() function in Google Sheets is as follows:

=ODD(value)

Where "value" is the number you want to round up to the nearest odd integer.

Note that if the given value is already an odd integer, the ODD() function will simply return that value without rounding.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!