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

could you post the formula?

On 17 Gru, 12:14, 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

=(I16-N16)/N16

"Jarek Kujawa" wrote:

could you post the formula?

On 17 Gru, 12:14, 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

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

If you get #VALUE!, that probably means you have text (maybe a space " " ?)
somewhere in either I16 or N16

You could use COUNT to test it:
=IF(COUNT(I16,N16),(I16-N16)/N16,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Funkyfido" wrote:
=(I16-N16)/N16

=IF(COUNT(I16,N16)=2,(I16-N16)/N16,"")
would be better, test it for both cells to contain numbers before computing
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---