Use Of EVEN
Original Value
|
Evenly Rounded
| |
1
|
2
|
=EVEN(C4)
|
1.2
|
2
|
=EVEN(C5)
|
2.3
|
4
|
=EVEN(C6)
|
25
|
26
|
=EVEN(C7)
|
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.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें