Versions Compared

Old Version 37

changes.mady.by.user Hees, Maarten van

Saved on

compared with

New Version 38

changes.mady.by.user Hees, Maarten van

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

is equivalent to the algorithm:

    If A<5 Then
    B=1
   ElseIf A>9 Then
    B=3
   Else
    B=2
   EndIf



A number of ELSEIF, LogExp can be provided in sequence in INCASE() to simulate a Select Case function.

Please note that you can also write the relation as:B=INCASE(A<5,THEN,1,ELSEIF,A>9,THEN,3,ELSE,2)

 

Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview