PHASE.SET

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

Syntax

=PHASE.SET(Condition, Text, TargetCell, [OverwriteFormula])

Arguments

Name	Type	Description
Condition	Formula	Condition to check for action.
Text	String	Text to copy to the target cell, if condition equals TRUE.
TargetCell	Cell	Cell to put text into.
OverwriteFormula (optional)	Boolean	Set to TRUE will overwrite cell formula. Default value: FALSE

Return

Type	Description
Boolean	Depends on condition. TRUE or FALSE

Examples

Formula	Result	Comment
=PHASE.SET(2>1, "Test", B1)	TRUE	Will put text "Test" in cell B1, as 2 is always larger than 1.
=PHASE.SET(2>1, "Test", B1, TRUE)	TRUE	Same as before, but overwrites possible cell formula so that "Test" is returned on subsequent App steps