Last Update: 12/6/2018
Yes, we added if() function since Origin 2019.
E.g. Suppose column A contains values with some missing values. Enter if(A=1/0, mean(A), A) in column B's F(X) cell, B will be filled with column A values if there is value in A; column B will be filled with mean of column A if the corresponding row in A is missing values or blank.
Before Origin 2019, please use "?" operator.
To do the same calculation above, enter A=1/0? Mean(A):A in column B's F(x) cell
A more complicated example: I have a series of row numbers in column A and want to fill column B with conditional sequences so that if the value in col(A) is
Enter A>=1&&A<=7?"Low":(A>7&&A<=17?"Mid":"High") in column B's F(x) cell
See also Excel and Origin Functions Comparison
Keywords:IF function, set values under condition, conditional operator