Log In
IBM Docs wiki
All Wikis
All Forums
Home
Product Documentation
Community Articles
Learning Center
IBM Redbooks
API Documentation
Community Articles
Product Documentation
Learning Center
IBM Redbooks
API Documentation
This category
Custom Search Scope...
Search
Share
▼
Subscribe
▼
Share
▼
Subscribe
▼
Installing and deploying IBM Docs 1.0.3
Select version
1.0.3 Installing and Deploying
1.0.3 Using IBM Docs
Using IBM Docs 1.0.3 documentation
Information
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
X
Conditional array calculations
Added by
IBM
on
June 24, 2013

Version 1
(
Original
)
Edit
More Actions
▼
Abstract
Abstract
A conditional array calculation is an array or matrix formula that includes an IF() function.
The condition argument in the formula is an area reference or a matrix result.
In the following example, the >0 test of the {=IF(A1:A3>0,"yes","no")} formula is applied to each cell in the range A1:A3 and the result is copied to the corresponding cell.
Table 1. Example of a conditional array calculation
A
B (formula)
B (result)
1
1
{=IF(A1:A3>0,"yes","no")}
yes
2
0
{=IF(A1:A3>0,"yes","no")}
no
3
1
{=IF(A1:A3>0,"yes","no")}
yes
Parent topic:
Array functions
Related reference
FREQUENCY function
Array functions
MMULT function
SUMPRODUCT function
Edit
More Actions
▼
Attachments (0)
Attachments (0)
Edit the article to add or modify attachments.
Versions (1)
Versions (1)
Version Comparison
Compare version
Current 1
with version
Current 1
Compare selected versions
Version
Date
Changed by
Summary of changes
This version (1)
Jun 24, 2013 9:54:14 PM
IBM
Comments (0)
Comments (0)
Add comment
Copy and paste this wiki markup to link to this article from another article in this wiki.
Link:
Close