Instead of
=IF(Y2="","",IF(Y20,"active",Y2))

you could use:
=IF(Y2="","NULL",IF(Y20,"active",Y2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Colin Hayes" wrote in message
...
Max

I've just had a little extra problem.

Could I use your formula to replace cells in the column with no content to
read 'NULL' , with cells having content remaining the same?

Best Wishes
Colin