{"id":2121,"date":"2019-07-05T15:51:45","date_gmt":"2019-07-05T14:51:45","guid":{"rendered":"https:\/\/help.cirrus-shield.com\/docs\/fields\/create-formula-field\/use-the-formula-operators\/"},"modified":"2019-07-05T15:53:10","modified_gmt":"2019-07-05T14:53:10","slug":"use-the-formula-operators","status":"publish","type":"docs","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/create-formula-field\/use-the-formula-operators\/","title":{"rendered":"Use the Formula Operators"},"content":{"rendered":"
\n
\n
\n
\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n\t\t\t\t\t\t\t\tOperator<\/b><\/span>\t\t\t\t\t\t\t<\/th>\n\n\t\t\t\t\t\t\t\tDescription<\/b><\/span>\t\t\t\t\t\t\t<\/th>\n<\/tr>\n<\/thead>\n
\n\t\t\t\t\t\t\tAdd<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tCalculates the sum of two values.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tSubstract<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tCalculates the difference of two values.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tMultiply<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tMultiplies its values.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tMAX<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tDisplay the highest value of the field you selected.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tMIN<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tDisplay the lowest value of the field you selected.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tDivide<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tDivides its values.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tExponentiation<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tRaises a number to a power of a specified number.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tOpen Parenthesis<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tSpecifies that the expressions within the open parenthesis is evaluated first.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tClose Parenthesis <\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tSpecifies that the expressions within the close parenthesis is evaluated the last.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tAbs <\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tCalculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tEquals<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if two values are equivalent.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tNot Equal To<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if two values are not equivalent.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tLess Than<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if a value is less than the value that follows this symbol.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tGreater Than<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if a value is greater than the value that follows this symbol.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tLess Or Equal<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if a value is less than or equal to the value that follows this symbol.\n\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tAnd<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if two values or expressions are both true. Use this operator as an alternative to the logical function AND.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\tOr<\/b>\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\tEvaluates if at least one of multiple values or expressions is true. Use this operator as an alternative to the logical function OR.\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n<\/div><\/div>\n<\/section>\n

<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1830,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_tag":[],"class_list":["post-2121","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/comments?post=2121"}],"version-history":[{"count":4,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2121\/revisions"}],"predecessor-version":[{"id":4604,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2121\/revisions\/4604"}],"up":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/1830"}],"next":[{"title":"Use the Formula Functions","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/create-formula-field\/use-the-formula-functions\/","href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2122"}],"wp:attachment":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/media?parent=2121"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/doc_tag?post=2121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}