PowerUp Description
The pwrIFBLANK PowerUp function checks if a value is blank. If it is, it returns a specified value.
PowerUp Syntax
pwrIFBLANK(value, value_if_blank)
The pwrIFBLANK PowerUp function has the following arguments:
value – Required. This is the value to check to see if it is empty. If value is empty, the empty value is returned.
value_if_blank – Required. This is returned if value is blank.
Return Value
pwrIFBLANK will return the original value if value is not blank. Otherwise it will return value_if_blank.
Remarks
None.
Example
=pwrIFBLANK(A1, "Cell A1 is blank.")
Would return “Cell A1 is blank.” if A1 was a blank cell.
