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 FunctionAvailable for custom calculations
=Yes
>=Yes
<=Yes
>Yes
<Yes
!=Yes
ABSYes
ACOSYes
ACOSHNo
ANDYes
ASINYes
ASINHNo
ATANYes
ATAN2No
ATANHNo
AVERAGENo
CEILINGNo
COMBINNo
COSYes
COSHYes
DEGREESYes
EVENNo
EXPYes
FACTYes
FALSEYes
FLOORYes
IFYes
INTYes
LNYes
LOGNo
LOG10Yes
MAXYes
MDTERMNo
MINYes
MINVERSENo
MMULTNo
MODYes
NOTYes
ODDNo
ORYes
PIYes
POWERNo
PRODUCTYes
RADIANSYes
RANDYes
ROMANNo
ROUNDYes
ROUNDDOWNNo
ROUNDUPNo
SIGNNo
SINYes
SINHYes
SQRTYes
STDDEVNo
SUBTOTALNo
SUMYes
SUMIFNo
SUMPRODUCTYes
SUMSQNo
SUMX2MY2No
SUMX2PY2No
XUMXMY2No
TANYes
TANHYes
TRUEYes
TRUNCNo
VARYes

Questions? Need a Quote? Contact Us.  1.800.248.9748