Round numbers up to the next even integer.
- number - the value to round
The function accepts a single number as its argument and will return the nearest even number to that number. For example, this formula will return 2 as the nearest even integer to 1.5.
The function can also accept negative numbers as its argument and, will return -2 as the nearest even integer to -1.
The function will return the same even number if the argument is already an even number,and will return 2 as the nearest even integer to 2.
The function will round up to the next even number if the argument is an odd number, and will return 4 as the nearest even integer to 3.
The EVEN function is used for rounding numbers up to the next even integer. Negative numbers are rounded away from zero and even integers are the next even integer up from the original number and zero.
- The EVEN function takes one argument - the argument should be a numeric value.
- The EVEN function rounds numbers away from zero and up to the next integer.
- All numbers are evenly rounded up to the next integer number.
Frequently Asked Questions
What is the EVEN function?
The EVEN function is a mathematical function in Sourcetable that rounds numbers up.
What is the purpose of the EVEN function?
The EVEN function is used to round numbers up to the nearest even number.
How do I use the EVEN function?
To use the EVEN function, you must enter the formula into a cell in your worksheet. The formula should look like this: =EVEN (number). Replace the â€œnumberâ€ with the number you would like to round up.
What are some examples of using the EVEN function?
- Rounding up 2.5 to the nearest even number: =EVEN (2.5) would return 4
- Rounding up 3.2 to the nearest even number: =EVEN (3.2) would return 4
- Rounding up 7.9 to the nearest even number: =EVEN (7.9) would return 8
What numbers can I use with the EVEN function?
You can use any numbers with the EVEN function, including positive and negative numbers and decimals.