SETVALUE

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

Syntax

=SETVALUE([Condition], Value, TargetCell, [OverwriteFormula])

Arguments

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

Return

Depends on condition. TRUE or FALSE

Examples

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