IF {ExcelFunctionsR}R Documentation

Basic If function from excel

Description

It acts similiarly to Excel's If function. Works on vectors as well. IF function is one of the first logical functions which has 3 arguments, logical test, value if true and value if false. If logical test passes(meaning it returns true) then function goes to value if true, otherwise it goes to value if false argument.

Usage

IF(logical_test, valueifTrue = 0, valueifFalse = 0)

Arguments

logical_test

This is the usual test we run in excel which returns either TRUE or FALSE value. Use double equal signs for logical test if you want to equal.

valueifTrue

If the logical_test evaluates to TRUE then function will return the value you input here

valueifFalse

If the logical_test evaluates to FALSE then function will return the value you input here

Value

In this example we test if Species equal virginica and if it does we get a return Yes, otherwise it returns No. Function can return different classes, it depends on what you specify in value if true and what you specify in value if false.

Examples

IF(iris$Species == "virginica","Yes","No")

[Package ExcelFunctionsR version 0.1.4 Index]