PowerUp Description
The pwrIFZERO PowerUp function checks if a value is equal to zero. If it is, it returns a specified value.
PowerUp Syntax
pwrIFZERO(value, value_if_zero)
The pwrIFZERO PowerUp function has the following arguments:
value – Required. This is the value to compare to zero. If not zero value is returned.
value_if_zero – Required. This is the value to return if value is equal to zero.
Return Value
pwrIFZERO will return the original value if value does not equal zero. Otherwise it will return value_if_zero.
Remarks
None.
Example
=pwrIFZERO(A1, "A1 is equal to zero.")
Would return “A1 is equal to zero.” if A1 was in fact equal to zero.
