Search

Learn Even Excel formula round a number up the nearest even whole number.

EVEN

Learn MS Excel Even formula How to use

 

What Does It Do ?
This function round a number up the nearest even whole number.

Syntax
=EVEN(Number)

Formatting
No special formatting is needed.

Example
The following table is used by a garage which repairs cars.
The garage is repairing a fleet of cars from three manufactures.
Each manufacturer uses a different type of windscreen wiper which are only supplied in pairs.

Table 1 was used to enter the number of wipers required for each type of car
and then show how many pairs need to be ordered.

Even formula Example Table
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply