大智慧条件表达式及其应用（Great wisdom of conditional expression and its application）.docVIP

大智慧条件表达式及其应用（Great wisdom of conditional expression and its application） 1, conditional expression: in the design formula, need to use a large number of conditional expressions, according to the results of the conditional expression to make a decision, in order to determine what to do next, what should not do. The basic conditions of expression by , , , =, =,, and, or comparison operator, logical operators, including and and or, and, or, or. The value of the conditional expression is only 2, 1 and 0. When the condition is set, it returns 1. If the condition is not valid, it returns 0. Here are some examples: Example 1:closeopen{means that the closing price is greater than the opening price. If it returns 1, otherwise the value of the conditional expression is 0}; Example 2:closeopen and closema (close, 5) {means that the closing price is greater than the opening price, and the close is greater than the average price of 5 days, and and is , and , and means two conditions are satisfied at the same time in order to make a judgment}; Example 3:closeref (close, 1) or close=ref (close, 2) {this closing is less than yesterdays closing, or todays closing is less than the previous 2 days closing price, or means or, or. This means that the two condition can be judged as long as one condition is satisfied; Note: in the example above, included in the half angle of a pair of braces {,} is the content of the comment statements will be run. A good formula design, need to spend a lot of effort, for a long time, it is possible that they will forget how to design, and in addition to other people can understand the formula, appropriate to add notes is a good habit. 2, IF conditional function: when designing formulas, the conditional function IF is very important, and is often used, as follows: IF conditional function, according to the conditions for different values. Usage: IF (X, A, B) returns A if X is not 0, otherwise returns B For example, IF (CLOSEOPEN, HIGH, LOW) indicates th