Formua returns a value of #Value!
And the formula expression is …? And which cell is empty (has no data)?
Please edit your question to provide the details. Thanks.
Make sure that the so called empty field is indeed empty (clean).
Maybe it is formatted as a non value like text.
Try typing in a zero (0) and see what happens.