aligahk06
10-27-2009, 05:57 AM
Dear All,
Can i convert below nested if function into a UDF.
Please assist ?
Rgds,
Aligahk06
=IF($B696="NEW INSULATION",CONCATENATE($B696,$D696,$C696,$E696,$G696),IF(AND($B696="NEW CLADDING",$C696="PIPE"),CONCATENATE($B696,$D696,$C696,$E696,$G696),IF($B696="NEW CLADDING",CONCATENATE($B696,$D696,$C696,$E696),IF(OR($B696="REMOVE CLADDING",$B696="REINSTALL CLADDING"),CONCATENATE($B696,$C696,$E696),IF(OR($B696="REMOVE INSULATION",$B696="REINSTALL INSULATION"),IF(AND($H696="COLD",OR($C696="PIPE",$C696="FLAT",$C696="ELBOW 900",$C696="FLANGE",$C696="VALVE")),CONCATENATE($B696,$D696,$C696,$E696),IF(OR($B696="REMOVE INSULATION",$B696="REINSTALL INSULATION"),CONCATENATE($B696,$D696,$C696,$E696),0)))))))
Can i convert below nested if function into a UDF.
Please assist ?
Rgds,
Aligahk06
=IF($B696="NEW INSULATION",CONCATENATE($B696,$D696,$C696,$E696,$G696),IF(AND($B696="NEW CLADDING",$C696="PIPE"),CONCATENATE($B696,$D696,$C696,$E696,$G696),IF($B696="NEW CLADDING",CONCATENATE($B696,$D696,$C696,$E696),IF(OR($B696="REMOVE CLADDING",$B696="REINSTALL CLADDING"),CONCATENATE($B696,$C696,$E696),IF(OR($B696="REMOVE INSULATION",$B696="REINSTALL INSULATION"),IF(AND($H696="COLD",OR($C696="PIPE",$C696="FLAT",$C696="ELBOW 900",$C696="FLANGE",$C696="VALVE")),CONCATENATE($B696,$D696,$C696,$E696),IF(OR($B696="REMOVE INSULATION",$B696="REINSTALL INSULATION"),CONCATENATE($B696,$D696,$C696,$E696),0)))))))