| Function | Execution | Desired Result | Correct? | Notes |
| ABS | 500 | |||
| CEILING | 3 | |||
| CEILING | 211 | |||
| CEILING | 210.70000000000002 | |||
| CEILING | 210.65000000000003 | |||
| CEILING | 4 | |||
| CEILING | -5 | |||
| EVEN | 2 | |||
| EVEN | 4 | |||
| EVEN | 2 | |||
| EVEN | -2 | |||
| EXP | 2.718281828459045 | |||
| FLOOR | 2 | |||
| FLOOR | -4 | |||
| FLOOR | 169 | |||
| FLOOR | 169.65 | |||
| FLOOR | 169.60000000000002 | |||
| FLOOR | 2 | |||
| FLOOR | 0 | |||
| FLOOR | -5 | |||
| INT | -5 | |||
| INT | 2 | |||
| LN | 2.995732273553991 | |||
| LOG | 1.301029995663981 | |||
| LOG10 | 1.301029995663981 | |||
| MOD | 1 | |||
| MOD | 2 | |||
| MOD | -6 | Excel says this value should be -7, but after research it looks as though this is an error in excel and the spreadsheets that mimic it. More here: http://support.microsoft.com/kb/141178 | ||
| MOD | 0 | |||
| MOD | ||||
| ODD | 35 | |||
| ODD | -35 | |||
| ODD | 211 | |||
| ODD | 3 | |||
| ODD | -3 | |||
| ODD | 7 | |||
| ODD | 9 | |||
| PI | 3.141592653589793 | |||
| POWER | 81 | |||
| POWER | 140.29611541307906 | |||
| POWER | 140.29611541307906 | |||
| RAND | Not Checkable | |||
| ROUND | 663 | |||
| ROUND | 662.8 | |||
| ROUND | 50 | |||
| ROUND | 60 | |||
| ROUND | -23.7 | |||
| ROUNDDOWN | 662 | |||
| ROUNDDOWN | 662.7 | |||
| ROUNDDOWN | 50 | |||
| ROUNDDOWN | 50 | |||
| ROUNDDOWN | -23.6 | |||
| ROUNDUP | 663 | |||
| ROUNDUP | 662.8 | |||
| ROUNDUP | 60 | |||
| ROUNDUP | 60 | |||
| ROUNDUP | -23.7 | |||
| TRUNC | 662 | |||
| TRUNC | 662 | |||
| TRUNC | 662.7 | |||
| TRUNC | 50 | |||
| TRUNC | 67 | |||
| TRUNC | -23.6 | |||
| SUMPRODUCT | ||||
| SUMPRODUCT |