Access Keys:
Skip to content (Access Key - 0)

How do I use conditional statements in Xess?

Xess allows you to use conditional statements using "@IF". Its syntax is:

@IF(X,T,F)      

Returns the value of T if X evaluates to non-zero, or F if X evaluates to zero
X - numeric value
T,F - numeric or string values, cell or range references

For example, to get the following condition:

IF G7<(C7+E7) AND H7<(D7+F7) THEN "YES" ELSE "NO"

Type in an another cell:

=@IF( G7 < C7+E7 && H7 < D7+F7, "YES", "NO")

NOTE: The "@IF" statement should be placed in a cell other than the cells specified within the (...) otherwise the result will be an infinite loop.

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

February 25, 2009

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
olc-xess olc-xess Delete
xess xess Delete
conditional conditional Delete
statement statement Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki