IF Function: Difference between revisions

From Planfix
Jump to: navigation, search
(Created page with "This function returns one of two values, depending on a condition. Format: '''*IF(condition;yes_value;no_value)''' '''*IF(condition;yes_value;no_value)''' where: ●...")
 
No edit summary
Line 2: Line 2:




Format:
''Format:''


'''*IF(condition;yes_value;no_value)'''
'''*IF(condition;yes_value;no_value)'''
Line 10: Line 10:
   
   


where:
''where:''


●      condition - logical expression using the symbols >, <, =, >=, <=, !=, another function or value
*condition - logical expression using the symbols >, <, =, >=, <=, !=, another function or value
 
*yes_value - number or string that the function returns if the condition is met
●      yes_value - number or string that the function returns if the condition is met
*no_value - number or string that the function returns if the condition is not met
 
●      no_value - number or string that the function returns if the condition is not met


   
   


Examples:
''Examples:''


IF(D="Text in column";"Good";"Bad")
*IF(D="Text in column";"Good";"Bad")


IF(D > 100500;"A lot";"A little")
*IF(D > 100500;"A lot";"A little")


IF(CONTAIN(L;"Qualification");G;"")
*IF([[CONTAIN]](L;"Qualification");G;"")


   
   


Notes:
●      the condition can be an arithmetic expression. If the result of this expression is a non-zero number, then the condition is considered to be fulfilled. If the result of the expression is zero, then the condition is considered not fulfilled.


●      the values can be expressions that use data from report columns or variables in calculated fields
'''Notes:'''


●      Use a "Yes"/"No" test to check a Checkbox custom field in a data tag or data tag calculated field. In other cases, without data tags, use a 1/0 check.
*the condition can be an arithmetic expression. If the result of this expression is a non-zero number, then the condition is considered to be fulfilled. If the result of the expression is zero, then the condition is considered not fulfilled
*the values can be expressions that use data from report columns or variables in calculated fields
*use a "Yes"/"No" test to check a Checkbox custom field in a data tag or data tag calculated field. In other cases, without data tags, use a 1/0 check.


   
   

Revision as of 17:37, 5 December 2019

This function returns one of two values, depending on a condition.


Format:

*IF(condition;yes_value;no_value)

*IF(condition;yes_value;no_value)


where:

  • condition - logical expression using the symbols >, <, =, >=, <=, !=, another function or value
  • yes_value - number or string that the function returns if the condition is met
  • no_value - number or string that the function returns if the condition is not met


Examples:

  • IF(D="Text in column";"Good";"Bad")
  • IF(D > 100500;"A lot";"A little")
  • IF(CONTAIN(L;"Qualification");G;"")



Notes:

  • the condition can be an arithmetic expression. If the result of this expression is a non-zero number, then the condition is considered to be fulfilled. If the result of the expression is zero, then the condition is considered not fulfilled
  • the values can be expressions that use data from report columns or variables in calculated fields
  • use a "Yes"/"No" test to check a Checkbox custom field in a data tag or data tag calculated field. In other cases, without data tags, use a 1/0 check.


Example

Depending on whether or not there is a number in column D, either return either that number or the number in column E:



<screenshot>



Particularities of working with formulas and functions

Please note the following:

● All arguments of the IF formula must be included (Condition;Action_IF_YES;Action_IF_NO);

● Nesting IF inside IFs is not limited, but the number of arguments must be correct;

● Empty NUMBER fields equal zero, and nothing more;

● Empty STRING fields and other fields (or not all) are entered as empty quotes: "";

● You can multiply by "-1";

● Line breaks cannot be used in formulas or when generating documents.