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

Depends on condition. TRUE or FALSE

Examples

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