Thread: #VALUE! Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bgcooker bgcooker is offline
external usenet poster
 
Posts: 13
Default #VALUE! Error

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?