HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
Using IBM Connections Docs 2.0 CR3Welcome to the IBM Connections Docs 2.0 CR3 documentation, where you can find information about IBM Docs 2.0 CR3. IBM Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
Using IBM DocsIBM Docs is a new office productivity suite for working on documents, spreadsheets and presentations—together—in the cloud. It provides real-time co-editing, allowing users to work on documents individually or collaboratively. Comment on a document, or even participate in a discussion. All this without the need of desktop software.
Working with spreadsheetsCalculate, analyze, and manage your data. Several categories of functions are available to create formulas to perform complex calculations on your data.
Using formulas in calculationsThis section provides background information on formulas and functions, and organizes the functions in alphabetical order or by category to make it easy to find related functions.
List of functionsUse these functions to create formulas for spreadsheet calculations.
IF functionIF specifies a logical test to be performed.

IF function

IF specifies a logical test to be performed.

Syntax

IF(test,then value,otherwise value)

test is any value or expression that can be TRUE or FALSE.
then value (optional) is the value that is returned if the logical test is TRUE.
otherwise value (optional) is the value that is returned if the logical test is FALSE.

In IBM® Connections Docs functions, parameters marked as optional can be omitted only when no parameter follows. For example, in a function with four parameters, where the last two parameters are optional, you can leave out parameter 4 or parameters 3 and 4. However, you cannot leave out parameter 3 alone.

Example

=IF(A1>5,100,"too small")

If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text "too small" (without quotes) is entered.