Difference between revisions of "Manuals/calci/EVEN"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
{| 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" | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 19:36, 18 November 2013
EVEN(number)
- Where 'number' is the input number.
EVEN() rounds the number to the nearest even integer value away from '0'.
Description
EVEN(number)
- For non-numeric number, Calci returns an #ERROR message.
- The number is rounded up away from zero to its nearest even integer, irrespective of its sign.
Examples
| Function | Output |
| EVEN(57) | 58 |
| EVEN(-23) | -24 |
| EVEN(34.98989898) | 36 |
| EVEN(-3.25) | -4 |
| EVEN(222) | 222 |