LogoLogo
Version 1.48
Version 1.48
  • nedyx
  • Welcome to nedyx
  • 🚀Getting started
    • Preparation
    • Basic widget formatting
    • The first formula
    • More formulas
    • Combine several tables
    • Add a new page
    • Widget references across pages
    • Add a chart widget
    • Further adjustments
  • 🖊️Working with nedyx
    • Apps
    • Live and Edit mode
    • The Header bar
    • Pages
    • Widgets
      • Widget types
      • Adding widgets
      • Widget selection
      • Widget positioning
      • Style tab
      • Content tab
      • Table widget types
      • Cell styles
      • Chart content
      • Chart properties
      • Undo / redo
    • Databases
      • Connect to a database
      • Get external data
    • File management
  • 📖ClearLines Functions
    • General Aspects
      • Formula structure
      • The formula editor
      • Actions
      • Calculated widget properties
        • Content property
        • Cell styles property
        • Chart labels
        • Column widths and Row heights
        • Connection property
        • Editable property
        • MinY and MaxY properties
        • Style property
        • Tooltips
        • Visible property
      • Ranges
      • Widget references
      • Widget cell references
      • Menu widget synchronization
    • Action functions
      • ACTIONCOLUMN
      • ACTIONCONTENT
      • ACTIONROW
      • CLICK
    • Database functions
      • CALLURL
      • EXECUTE
      • GETDATA
      • GETDBCOLUMNNAMES
      • GETSTATEMENT
    • Date functions
      • CREATEDATE
      • DATE
      • DATETOTEXT
      • DAY
      • GETTIMEZONEOFFSET
      • HOUR
      • MILLISECOND
      • MINUTE
      • MONTH
      • SECOND
      • TODAY
      • WEEKDAY
      • YEAR
    • Import / export functions
      • DOWNLOAD
      • DELETEFILE
      • DOWNLOADFILE
      • EXCELCREATE
      • GETFILELIST
      • PDFCREATE
      • POSTMESSAGE
      • SCANCODE
      • SENDEMAIL
      • UPLOAD
      • UPLOADFILE
    • Logical functions
      • AND
      • IF
      • ISEMPTY
      • ISUSERACTION
      • LOOP
      • NOT
      • OR
    • Mathematical functions
      • ABS
      • EXP
      • LN
      • LOG
      • MAX
      • MIN
      • MOD
      • MROUND
      • NUMBER
      • PI
      • RAND
      • ROUND
      • SQRT
      • SUM
    • Navigation functions
      • CLOSE
      • GETURLPARAM
      • MESSAGE
      • OPEN
      • OPENWEBPAGE
      • QUESTION
    • Range functions
      • AGGREGATE
      • CELL
      • CELLREF
      • CLEAR
      • COLUMN
      • COLUMNS
      • COMBINE
      • CONVERT
      • COUNT
      • CSVTORANGE
      • CUMULATE
      • DIFF
      • EMPTY
      • FILTER
      • GETTYPE
      • INSERTRANGE
      • INTERSECTION
      • LOOKUP
      • RANGE
      • RANGETOCSV
      • RANGETOHIERARCHY
      • ROW
      • ROWS
      • SEQUENCE
      • SORT
      • TRANSPOSE
      • UNIQUE
      • VISIBLEHIERARCHY
    • Text functions
      • CHAR
      • CODE
      • CREATEMEMBER
      • FIND
      • HIDDENTEXT
      • HTMLTOJSONTEXT
      • LEFT
      • LEN
      • LOWER
      • MID
      • RIGHT
      • SUBSTITUTE
      • TEXT
      • TRIM
      • UPPER
    • User management functions
      • APPLIST
      • ADDUSER
      • APPSHARELIST
      • REMOVEUSER
      • SHAREAPP
      • UPDATEUSER
      • USERLIST
      • USERNAME
    • Widget functions
      • GETSELECTION
      • LOADWIDGETCONTENT
      • NAME
      • PAGE
      • SETSELECTION
      • STOREWIDGETCONTENT
      • UPDATE
  • 🔐Security
    • User Management
      • Workspaces
      • Workspace Roles
      • Adding Users to a Workspace
      • App Roles
      • Share an App with Other Users
      • Guest Access
      • Change Password
  • Appendix
    • Keyboard shortcuts
    • Error handling
    • Feature preview
    • Supported browsers
    • System requirements for on-premises installations
Powered by GitBook
On this page
  1. ClearLines Functions
  2. Logical functions

IF

Evaluates an expression if a corresponding condition is true.

PreviousANDNextISEMPTY

Syntax

IF(condition; thenExpression; elseExpression)

  • condition - the condition which is evaluated - Value type: boolean

  • thenExpression - expression which is evaluated if condition is true - Value type: any

  • elseExpression - expression which is evaluated if condition is false - Value type: any (optional, default: empty)

Return

The function returns the result of the evaluated then- or elseExpression.

Remarks

  • The function can be called with multiple condition/thenExpression parameter pairs as well. In this case, the evaluation of the functions stops after the first condition which is true. If none of the conditions is true, elseExpression is evaluated.

Examples

In this case, after clicking on the button, table3 is filled with the information if the values of table4 are positive, negative or zero. The IF function is used here with 5 parameter, and the result is used to fill a table widget.

📖