Excel Iseven isodd Judge parity

Source: Internet
Author: User
Tags integer numeric numeric value truncated

First, IsEven function

function function: To determine whether the numeric value is even, if it is, return true, otherwise return false;

Syntax: ISEVEN (number)

Number to be tested. If the parameter value is not an integer, the subtotal is automatically truncated. Note: This function must be loaded by the Analysis ToolPak before it can be used.

If the argument number is not a numeric value, the IsEven function returns an error value of #value!.

Example:

If the value of A1 is 2, then the function =iseven (A1) returns True

You can also use values directly without referring to cell addresses, such as:

=iseven (100) returns True

Second, isodd function

function function: To determine whether the value is odd, if it is, return true, otherwise return false;

Syntax: isodd (number)

Number to be tested. If the parameter value is not an integer, the subtotal is automatically truncated.

If the argument number is not a numeric value, the IsEven function returns an error value of #value!.

Example:

If the value of Z1 is 99, then the function =isodd (Z1) returns True

You can also use values directly without referring to cell addresses, such as:

=iseven (100) returns false

IsEven and IsOdd, these two functions are specifically used to judge the parity, in the use of the process, you use which function is OK, as long as the flexibility to use, which can be used to judge the parity, not necessarily two use.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.