Summary Description. Assemble, install, or maintain solar photovoltaic (PV) systems on roofs or other structures in compliance with site assessment and schematics. May include measuring, cutting, assembling, and bolting structural framing and solar modules. May perform minor electrical work such as current checks.
IFERROR(value, value_if_error) The IFERROR function syntax has the following arguments: Value Required. The argument that is checked for an error. Value_if_error Required. The value to return if the formula evaluates to an error.
Most often, the INDIRECT function returns a #REF! error in three cases: 1. ref_text is not a valid cell reference. If the ref_text parameter in your Indirect formula is not a valid cell reference, the formula will result in the #REF! error value. To avoid possible issues, please check the INDIRECT function's arguments. To prevent this, you can wrap the INDIRECT function in the IF function: IF(OR($A$1=,B1=), , INDIRECT(' & $A$1 & '! & B1)). 2  For the INDIRECT formula that refers to another sheet to work correctly, the referred sheet should be open, otherwise the formula will return a #REF error.