They allow such relations as <, >, and <> (not equal), which are not easily handled by current optimization methods, as well as such logical operators as AND, OR and NOT. Second, relations such as A1 >= 0, are evaluated by the spreadsheet as strictly satisfied or unsatisfied, whereas an optimization algorithm evaluates constraints within a tolerance.