Using Excel math functions in custom calculations
X-RiteColor Master software has the ability to use custom calculations in the L*a*b* Data view. These calculations can use a subset of the math functions available in Excel. The table below outlines which functions are available to be used in these custom calculations.
| Excel Math Function | Available for custom calculations |
| = | Yes |
| >= | Yes |
| <= | Yes |
| > | Yes |
| < | Yes |
| != | Yes |
| ABS | Yes |
| ACOS | Yes |
| ACOSH | No |
| AND | Yes |
| ASIN | Yes |
| ASINH | No |
| ATAN | Yes |
| ATAN2 | No |
| ATANH | No |
| AVERAGE | No |
| CEILING | No |
| COMBIN | No |
| COS | Yes |
| COSH | Yes |
| DEGREES | Yes |
| EVEN | No |
| EXP | Yes |
| FACT | Yes |
| FALSE | Yes |
| FLOOR | Yes |
| IF | Yes |
| INT | Yes |
| LN | Yes |
| LOG | No |
| LOG10 | Yes |
| MAX | Yes |
| MDTERM | No |
| MIN | Yes |
| MINVERSE | No |
| MMULT | No |
| MOD | Yes |
| NOT | Yes |
| ODD | No |
| OR | Yes |
| PI | Yes |
| POWER | No |
| PRODUCT | Yes |
| RADIANS | Yes |
| RAND | Yes |
| ROMAN | No |
| ROUND | Yes |
| ROUNDDOWN | No |
| ROUNDUP | No |
| SIGN | No |
| SIN | Yes |
| SINH | Yes |
| SQRT | Yes |
| STDDEV | No |
| SUBTOTAL | No |
| SUM | Yes |
| SUMIF | No |
| SUMPRODUCT | Yes |
| SUMSQ | No |
| SUMX2MY2 | No |
| SUMX2PY2 | No |
| XUMXMY2 | No |
| TAN | Yes |
| TANH | Yes |
| TRUE | Yes |
| TRUNC | No |
| VAR | Yes |
