How to determine odd and even numbers in Excel

Video How to determine odd and even numbers in Excel

Excel is one of the software that is indispensable on everyone's computer, especially for the accounting industry, it helps us to statistic , calculate data quickly and make financial statements. ...

One of the jobs that most accountants have to do is to distinguish odd and even numbers in Excel , which will help us calculate the advanced values ​​and set the necessary indices. If you do not know how to determine odd and even numbers , please refer to the following article.

Download Microsoft Office 2016 Download Microsoft Office on 2019

1. How to determine an even number with the ISEVEN function

Step 1: Open the file you want to execute.

Step 2: At any cell in the ISEVEN column, enter the formula: = IF (ISEVEN (The cell value to be calculated), "Even number", "") .

How to determine odd and even numbers in Excel

Inside:

  • IF: conditional function.
  • ISEVEN: is a function for determining even numbers.
  • Even number : is the value returned when checking that number is true for the condition.

Step 3: Press Enter , this time the results will be displayed in the cell you perform.

Step 4: With the remaining cells, people drag and drop the mouse down. Results after implementation:

How to determine odd and even numbers in Excel

2. How to distinguish odd numbers using ISODD function

Step 1: Open the data table you want to calculate.

Step 2: Click on any cell in the ISODD column, we enter the following formula: = IF (ISODD (The cell value to be calculated), "Odd number", "") .

Attention: 

  • IF: is a conditional function.
  • ISODD: is the function of determining odd numbers.
  • Odd number: is the result after checking the value to calculate the condition.

How to determine odd and even numbers in Excel

Step 3: Press Enter .

Step 4: If you want to continue counting the remaining cells, drag and drop down. Here are the results after following the steps:

How to determine odd and even numbers in Excel

After we have consulted how to determine parity numbers in Excel, we hope this can be a part of everyone's work. In addition, people can refer to some other articles such as: Separating negative and positive numbers in Excel , Creating Watermark on Excel , Converting numbers into letters in Excel with VnTools , ....

I wish you successful implementation!

Sign up and earn $1000 a day ⋙

Leave a Comment

5 gadgets that turn a regular TV into a smart one

5 gadgets that turn a regular TV into a smart one

A regular TV can still learn new tricks with a few gadgets and become better than an expensive smart TV in minutes.

How to use Panasonic air conditioner remote control

How to use Panasonic air conditioner remote control

Using Panasonic air conditioner remote control properly will help us take advantage of the features on the air conditioner.

Gemini rolls out Talk Live about for photos, files, and YouTube

Gemini rolls out Talk Live about for photos, files, and YouTube

Gemini Live has added a “Talk Live about” feature, and it’s now rolling out more widely to Android devices. Previously, Gemini Live only accepted voice input, but “Talk Live about” has expanded the content uploads

Microsoft Copilot Upgraded with Deep Research

Microsoft Copilot Upgraded with Deep Research

Microsoft is finally bringing Deep Research functionality to its Copilot AI. It allows users to conduct in-depth, multi-step research on any topic.

How to Turn a Photo into a Pencil Sketch in Photoshop

How to Turn a Photo into a Pencil Sketch in Photoshop

This tutorial will show you how to easily turn a photo into a pencil sketch using Adobe Photoshop.

Volatile functions in Golang

Volatile functions in Golang

Variadic functions in Go allow you to pass a variable number of arguments to a function. Here's everything you need to know about variadic functions in Golang.

How to write color letters in Lien Quan Mobile

How to write color letters in Lien Quan Mobile

To write colored letters in Lien Quan Mobile, follow the instructions in this article. Colored letters in LQ Mobile will attract more attention.

7 Task Manager Processes That Should Never End

7 Task Manager Processes That Should Never End

The Windows system processes section, located at the bottom of the list in Windows 10 Task Manager, contains several important processes that are essential for your computer to run properly.

Apple allows users to stay on iOS 15.7 before upgrading to iOS 16

Apple allows users to stay on iOS 15.7 before upgrading to iOS 16

Apple allows users to stay on iOS 15 while still receiving security updates before upgrading to iOS 16.

Intel Core Ultra 5 225H, Core Ultra 7 255H and Core Ultra 9 285H CPU performance evaluation results are available on Geekbench

Intel Core Ultra 5 225H, Core Ultra 7 255H and Core Ultra 9 285H CPU performance evaluation results are available on Geekbench

Three SKUs from Intel's upcoming Arrow Lake-H mobile lineup have been tested on Geekbench, revealing pretty impressive single-core and multi-core performance and specifications.

Who would have thought that the process of producing familiar rubber bands is so complicated and elaborate?

Who would have thought that the process of producing familiar rubber bands is so complicated and elaborate?

Those little rubber bands look simple, but the process of making them is more complicated than you might think. Here’s the complete process of making rubber bands.

9 interesting facts about Mercury

9 interesting facts about Mercury

Mercury is the smallest planet in the Solar System and also the closest planet to the Sun. Mercury orbits the Sun at an incredibly fast speed, averaging nearly 106,000 miles per hour. These are just a few of the many interesting facts about this planet.

What are the sizes of 32-inch, 40-inch, 43-inch, 55-inch TVs... from Sony, Samsung, LG?

What are the sizes of 32-inch, 40-inch, 43-inch, 55-inch TVs... from Sony, Samsung, LG?

The article below will help you understand the sizes of current TV lines from Sony, Samsung, and LG so you can make the right purchase decision.

7 Simple Tech Tweaks That Dramatically Improve Your Quality of Life

7 Simple Tech Tweaks That Dramatically Improve Your Quality of Life

Creating a healthy relationship with technology can seem daunting, but small changes often make a big difference.

8 Things You Didnt Know You Could Do in the Samsung Gallery App

8 Things You Didnt Know You Could Do in the Samsung Gallery App

Samsung's Gallery app is more capable than you might think, but that might not be immediately obvious.