Difference between revisions of "Translations:Expressions/134/en"
(Importing a new version from external source) |
(Importing a new version from external source) |
||
Line 3: | Line 3: | ||
Examples: | Examples: | ||
'''IF(("Price" > 0) && ("Seller" == 'John Snow');450;0)''' - If ''Price'' is greater than ''0'' '''AND''' ''Seller'' is equal to ''John Snow'', returns ''450'' if not returns ''0'' | '''IF(("Price" > 0) && ("Seller" == 'John Snow');450;0)''' - If ''Price'' is greater than ''0'' '''AND''' ''Seller'' is equal to ''John Snow'', returns ''450'' if not returns ''0'' | ||
− | |||
'''IF(("City" != "#null") && ("Product" != 'Lasagna');1;0)''' - If ''City'' is non-null '''AND''' ''Product'' is different from ''Lasagna'' returns ''1'' if it does not return ''0'' | '''IF(("City" != "#null") && ("Product" != 'Lasagna');1;0)''' - If ''City'' is non-null '''AND''' ''Product'' is different from ''Lasagna'' returns ''1'' if it does not return ''0'' |
Latest revision as of 14:25, 19 November 2020
Syntax:
<expression> && <expression>
Examples:
IF(("Price" > 0) && ("Seller" == 'John Snow');450;0) - If Price is greater than 0 AND Seller is equal to John Snow, returns 450 if not returns 0 IF(("City" != "#null") && ("Product" != 'Lasagna');1;0) - If City is non-null AND Product is different from Lasagna returns 1 if it does not return 0