EVEN
TheEVEN
function rounds a given value up to the nearest even integer. This function is commonly used when dealing with financial data, as many financial calculations require the use of even numbers.
 How to use
EVEN
formula?  Examples of using
EVEN
formula EVEN
formula not working? Similar formulas to
EVEN
Usage
Use the EVEN
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to be rounded up to the nearest even integer.
Examples
Here are a few example use cases that explain how to use theEVEN
formula in Google Sheets.
Round up to nearest even integer
Use EVEN
to round up a given value to the nearest even integer. For example, if you have a list of numbers representing sales amounts, you may want to round them up to the nearest even dollar amount.
Calculate even payment amounts
If you need to divide a total payment amount evenly between a certain number of people, you can use EVEN
to round the result up to the nearest even dollar amount. This ensures that everyone pays an equal amount.
Calculate even time intervals
If you need to schedule events or tasks at even time intervals, you can use EVEN
to round up the time interval to the nearest even number. For example, if you want to schedule events every two hours, you can use EVEN
to round up to the nearest even number of hours.
Common Mistakes
EVEN
not working? Here are some common mistakes people make when using the EVEN
Google Sheets Formula:
Missing argument
This error occurs when the user forgets to provide the value argument to the EVEN formula. To fix this error, make sure to include the value argument in the formula.
Incorrect argument type
This error occurs when the user provides an argument that is not a number to the EVEN formula. To fix this error, make sure to provide a valid number as the value argument.
Incorrect rounding
This error occurs when the user expects the EVEN formula to round a number to the nearest even integer, but the formula actually rounds down to the nearest even integer. To fix this error, use the ROUND function to round the number to the nearest integer first, and then use the EVEN function to round down to the nearest even integer.
Related Formulas
The following functions are similar to EVEN
or are often used with it in a formula:

ODD
The
ODD
function rounds up a given value to the nearest odd integer. It takes one required parameter,value
, which is the number to be rounded up. This function is commonly used in scenarios where only odd values are acceptable, such as in lottery games and sports scoreboards. 
INT
The
INT
formula rounds a given value down to the nearest integer. This formula is often used to simplify large numbers or to convert decimal values to integers. The formula takes a single parameter, the value to be rounded down. If the value is already an integer, the formula will return the same value. If the value is a decimal, the formula will round down to the nearest integer. 
CEILING
The
CEILING
function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments. 
FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.
Learn More
You can learn more about the EVEN
Google Sheets function on Google Support.