Miscellaneous Functions

@CALCMODE—This function enables you to specify whether a formula is calculated in cell mode or block mode and whether a formula is calculated bottom-up or top-down
@CONCATENATE, @SUBSTRING, and @NAME—These functions enable manipulation of character strings.
@RETURN—This function enables termination of a calculation, with a custom error message.
@CREATEBLOCK—This function populates cells with values or #MISSING.