EVEN Function (Functions in Excel)
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. |
Table 1 | |||
Car | Wipers To Order | Pairs to Order | |
Vauxhall | 5 | 3 | =EVEN(D28)/2 |
Ford | 9 | 5 | =EVEN(D29)/2 |
Peugeot | 7 | 4 | =EVEN(D30)/2 |
0 comments:
Post a Comment