AND: Basic AND function from excel

Description Usage Arguments Value Examples

View source: R/AND.R

Description

It acts similiarly to Excel's AND function. You give the function logical arguments and it either returns true or false.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
AND(
  logical1,
  logical2 = TRUE,
  logical3 = TRUE,
  logical4 = TRUE,
  logical5 = TRUE,
  logical6 = TRUE,
  logical7 = TRUE,
  logical8 = TRUE,
  logical9 = TRUE,
  logical10 = TRUE,
  logical11 = TRUE,
  logical12 = TRUE,
  logical13 = TRUE,
  logical14 = TRUE,
  logical15 = TRUE,
  logical16 = TRUE,
  logical17 = TRUE,
  logical18 = TRUE,
  logical19 = TRUE,
  logical20 = TRUE,
  logical21 = TRUE,
  logical22 = TRUE,
  logical23 = TRUE,
  logical24 = TRUE,
  logical25 = TRUE,
  logical26 = TRUE,
  logical27 = TRUE,
  logical28 = TRUE,
  logical29 = TRUE,
  logical30 = TRUE,
  logical31 = TRUE,
  logical32 = TRUE
)

Arguments

logical1, logical2, logical3, logical4, logical5, logical6, logical7, logical8, logical9, logical10, logical11, logical12, logical13, logical14, logical15, logical16, logical17, logical18, logical19, logical20, logical21, logical22, logical23, logical24, logical25, logical26, logical27, logical28, logical29, logical30, logical31, logical32

Specify logicals as arguments. The function follows OR logic.

Value

In the example we take a built-in dataset called iris and see which species are called setosa and which one has a petal length of 1.4. If both of these conditions return true then the final answer will also be true. Function will always return a logical class.

Examples

1
AND(iris$Species == "setosa", iris$Petal.Length == 1.4)

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.