Versions Compared

Old Version 34

changes.mady.by.user Hees, Maarten van

Saved on

compared with

New Version 35

changes.mady.by.user Hees, Maarten van

Saved on

Key

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

...

  • EQ -> Equal to (=)
  • NE -> Not Equal to ()
  • LT -> Lower Than (<)
  • GT -> Greater Then (>)
  • LE -> Lower than or Equal to (<=)
  • GE -> Greater of Equal to (=>)

...

B=INCASE(A,LT,5,THEN,1,ELSEIF,A,GT,9,THEN,3,ELSE,2)

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.

...