Formula required

  • Thread starter Thread starter Funkyfido
  • Start date Start date
F

Funkyfido

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
 
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
Click to expand...

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
 
Back
Top