1. A method performed by a processor for executing a formula having operands and an operator in an application program, comprising: retrieving data corresponding to a first operand for the operator of the formula; identifying a first dimension associated with the first operand; retrieving data corresponding to a second operand for the operator of the formula; identifying a second unit type associated with the second operand; determining whether the second unit type is compatible with the first unit type; if the second unit type is not compatible with the first unit type, converting the data corresponding to the second operand into a compatible value in terms of the first unit type; and producing a result of the formula using the converted data.