#VALUE! ERROR

Hi, I have some cells that have #value! error as there are elements missing from some of the cells included in the formula. I would like to replace the ones that get this with text 'NOT AVAILABLE' b...