VALUE.SET

Writes a given value into target cell, if specified condition evaluates to true.

Syntax

=VALUE.SET([Condition], Value, TargetCell, [OverwriteFormula])

Arguments

Name	Type	Description
Condition (optional)	Formula	Condition to check for action. Defaults to FALSE if no condition is given.
Value	Value	Value to write to target cell, if condition evaluates to TRUE.
TargetCell	Cell	Cell to put value into.
OverwriteFormula (optional)	Boolean	Set to TRUE remove any cell formula. Default value: FALSE

Return

Type	Description
Boolean	TRUE, if successful

Examples

Formula	Result	Comment
=VALUE.SET(21, 42, B1)	TRUE	Will put value 42 in cell B1, but keeps possible cell formula
=VALUE.SET(21, 42, B1, TRUE)	TRUE	Same as before, but overwrites possible cell formula so that 42 is returned on subsequent App steps
=VALUE.SET(, 42, B1)	TRUE	Does nothing because no condition is specified