Difference between revisions of "Translations:Expressions/155/en"

From TaticView
Jump to: navigation, search
(Importing a new version from external source)
 
(Importing a new version from external source)
 
Line 3: Line 3:
 
Examples:
 
Examples:
 
   '''IF(BETWEEN("Value";0;100);10;250)''' - If ''Value'' is between ''0'' and ''100'' returns ''10'', if not ''250''
 
   '''IF(BETWEEN("Value";0;100);10;250)''' - If ''Value'' is between ''0'' and ''100'' returns ''10'', if not ''250''
 +
  '''IF("Profit" == 0;0;"Profit" + "Taxes")''' - If ''Profit'' equals ''0'' returns ''0'', if it does not return the sum between ''Profit'' and ''Taxes''
 +
  '''IF("Product Code" == 3231;0;"Quantity" * 3;"Quantity")''' - If ''Product Code'' equals ''3231'' returns ''Quantity'' plus 3

Latest revision as of 14:25, 19 November 2020

Information about message (contribute)

This message has no documentation. If you know where or how this message is used, you can help other translators by adding documentation to this message.

Message definition (Expressions)
Syntax:
   IF(<expression to be tested>; <expression if true>; <expression if false>)
Examples:
  '''IF(BETWEEN("Value";0;100);10;250)''' - If ''Value'' is between ''0'' and ''100'' returns ''10'', if not ''250''
  '''IF("Profit" == 0;0;"Profit" + "Taxes")''' - If ''Profit'' equals ''0'' returns ''0'', if it does not return the sum between ''Profit'' and ''Taxes''
  '''IF("Product Code" == 3231;0;"Quantity" * 3;"Quantity")''' - If ''Product Code'' equals ''3231'' returns ''Quantity'' plus 3
TranslationSyntax:
   IF(<expression to be tested>; <expression if true>; <expression if false>)
Examples:
  '''IF(BETWEEN("Value";0;100);10;250)''' - If ''Value'' is between ''0'' and ''100'' returns ''10'', if not ''250''
  '''IF("Profit" == 0;0;"Profit" + "Taxes")''' - If ''Profit'' equals ''0'' returns ''0'', if it does not return the sum between ''Profit'' and ''Taxes''
  '''IF("Product Code" == 3231;0;"Quantity" * 3;"Quantity")''' - If ''Product Code'' equals ''3231'' returns ''Quantity'' plus 3

Syntax:

  IF(<expression to be tested>; <expression if true>; <expression if false>)

Examples:

 IF(BETWEEN("Value";0;100);10;250) - If Value is between 0 and 100 returns 10, if not 250
 IF("Profit" == 0;0;"Profit" + "Taxes") - If Profit equals 0 returns 0, if it does not return the sum between Profit and Taxes
 IF("Product Code" == 3231;0;"Quantity" * 3;"Quantity") - If Product Code equals 3231 returns Quantity plus 3