#VALUE! Error
Maybe
=IF(ISERROR(E8/C8),"",E8/C8)
Regards,
Stefi
€˛bgcooker€¯ ezt Ć*rta:
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?
|