=if(ISERROR(E8/C8),"",E8/C8)
or
=IF(COUNT(E8,C8)=2,E8/C8,"")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"bgcooker" wrote in message
...
I have a cell in F8 with the formula =E8/C8, that references a formula in
E8
containing an IF function formual: =IF((D8-C8)<=0,"",(D8-C8)). These
formulas are used throughout the spreadsheet.

A #VALUE! shows in column F if there are no values in the cells referred
to
in the formulas. Is there a way to stop this from showing in the
spreadsheet?