Forum Discussion
stephurso
Jan 21, 2022Copper Contributor
#VALUE Error when no value in cell
Hello, I have a spreadsheet with cell F73 to multiply two cells =D73*E73. When a value is not in cell E73, Cell F73 displays #Value. How do I get rid of that error? Once I place a value in E7...
- Jan 21, 2022Replace the double quotes with a 0.
Detlef_Lewin
Jan 21, 2022Silver Contributor
Most probably there is a text value in E73.