Forum Discussion
Solved
#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...
- Replace the double quotes with a 0.
You are correct. There is a formula in that field that pulls in a cost from another field.
=IFERROR(VLOOKUP(B73,Parts,4,FALSE),"")
=IFERROR(VLOOKUP(B73,Parts,4,FALSE),"")
Replace the double quotes with a 0.
- Thank you so much! This worked. I can't tell you how much time this will save everyone. So grateful to have logged into this forum.
Steph