In OpenClinica, one useful feature of CRF Excel templates is the ability to create calculations. There are a number of supported functions, including sum(), min(), and max(). There is also an interesting function call the decode() function, which allows you to essentially create an IF-THEN-ELSE type of statement.
To learn more about the decode() function and it’s uses, please visit this OpenClinica blog post.