SETPHASE

Puts the Text into the target cell, if the condition is true.

Syntax

=SETPHASE(Condition, Text, TargetCell [, OverwriteFormula])

Arguments

Name Description
Condition Condition to check for action.
Text Text to copy to the target cell, if condition equals TRUE.
TargetCell Cell to put text into.
OverwriteFormula Optional. Set to TRUE will overwrite cell formula. Defaults to FALSE.

Return Value

Depends on condition. TRUE or FALSE

Example

Function Result Comment
=SETPHASE(2>1, “Test”, B1) TRUE Will put text “Test” in cell B1, as 2 is always larger than 1.
=SETPHASE(2>1, “Test”, B1, TRUE) TRUE Same as before, but overwrites possible cell formula so that “Test” is returned on subsequent machine steps