EVEN Formula in Excel

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.

Table 1