On Wed, 17 Dec 2008 03:14:07 -0800, Funkyfido
wrote:

I have the following formula but the result comes back as #value because the
cell is still blank.

Is there another formula that I could use so that I no longer get this error?

Thanks

One way:

=IF(ISERR(your_formula),"",your_formula)
--ron