Difference between revisions of "Manuals/calci/EVEN"
Jump to navigation
Jump to search
| (15 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | = EVEN( | + | <div style="font-size:30px">'''EVEN(Number)'''</div><br/> |
| − | + | *where <math>Number</math> is the input number. | |
| − | * | + | **EVEN() rounds the number to the nearest even integer away from zero. |
| − | EVEN() rounds the number to the nearest even integer | ||
== Description == | == Description == | ||
EVEN(number) | EVEN(number) | ||
| − | + | EVEN(51) ''returns 52'' | |
| − | *The | + | *For a non-numeric <math>Number</math>, Calci returns an #NULL error message. |
| + | *The <math>Number</math> is rounded up away from zero to its nearest even integer, irrespective of its sign. | ||
| + | *EVEN() can be used with array of numbers as - | ||
| + | In ZOS: | ||
| + | *EVEN(1..10) or | ||
| + | *1..10@EVEN | ||
| + | In Calci: | ||
| + | *=EVEN(1..10) or | ||
| + | *=1..10@EVEN | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! Numbers !! EVEN | ||
| + | |- | ||
| + | | 1 || 2 | ||
| + | |- | ||
| + | | 2 || 2 | ||
| + | |- | ||
| + | | 3 || 4 | ||
| + | |- | ||
| + | | 4 || 4 | ||
| + | |- | ||
| + | | 5 || 6 | ||
| + | |- | ||
| + | | 6 || 6 | ||
| + | |- | ||
| + | | 7 || 8 | ||
| + | |- | ||
| + | | 8 || 8 | ||
| + | |- | ||
| + | | 9 || 10 | ||
| + | |- | ||
| + | | 10 || 10 | ||
| + | |} | ||
== Examples == | == Examples == | ||
| Line 16: | Line 48: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class=" " | '''Function''' | |
| − | + | | class=" " | '''Output''' | |
| − | + | ||
| − | | class=" " | | ||
| − | | class=" " | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |EVEN(57) | |
| − | + | | class="sshl_f" |58 | |
| − | | class="sshl_f" | | + | |
| − | | class="sshl_f" | | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |EVEN(-23) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |-24 |
| − | | class="sshl_f | + | |
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |EVEN(34.98989898) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |36 |
| − | | class="sshl_f" | | + | |
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |EVEN(-3.25) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |-4 |
| − | | class="sshl_f" | | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |EVEN(222) | |
| − | + | | class="sshl_f" |222 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| − | | class="sshl_f" | | ||
|} | |} | ||
| − | + | ==Related Videos== | |
| − | + | ||
| − | + | {{#ev:youtube|SFRTTUtAjg4|280|center|EVEN}} | |
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/ISEVEN | ISEVEN]] | ||
| + | |||
| + | *[[Manuals/calci/ODD | ODD]] | ||
| + | |||
| + | *[[Manuals/calci/TRUNC | TRUNC]] | ||
| + | |||
| + | *[[Manuals/calci/INT | INT]] | ||
| + | |||
| + | *[[Manuals/calci/CEILING | CEILING]] | ||
| + | |||
| + | *[[Manuals/calci/FLOOR | FLOOR]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Even_and_odd_functions EVEN Function] | ||
| + | *[http://simple.wikipedia.org/wiki/Even_number EVEN Number] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:00, 11 January 2019
EVEN(Number)
- where is the input number.
- EVEN() rounds the number to the nearest even integer away from zero.
is the input number.
Description
EVEN(number)
EVEN(51) returns 52
- For a non-numeric , Calci returns an #NULL error message.
- The is rounded up away from zero to its nearest even integer, irrespective of its sign.
- EVEN() can be used with array of numbers as -
In ZOS:
- EVEN(1..10) or
- 1..10@EVEN
In Calci:
- =EVEN(1..10) or
- =1..10@EVEN
| Numbers | EVEN |
|---|---|
| 1 | 2 |
| 2 | 2 |
| 3 | 4 |
| 4 | 4 |
| 5 | 6 |
| 6 | 6 |
| 7 | 8 |
| 8 | 8 |
| 9 | 10 |
| 10 | 10 |
Examples
| Function | Output |
| EVEN(57) | 58 |
| EVEN(-23) | -24 |
| EVEN(34.98989898) | 36 |
| EVEN(-3.25) | -4 |
| EVEN(222) | 222 |
Related Videos
See Also
References