Is there a way to get a cell that is referencing a formula to not show #value
before there is datat that will complete the cell. I am using Excel 07.

Thanks in advance.