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 E73 than its fine. How do I get Excel to have E73 be calculated as zero until a number is placed in? At the end of spreadsheet I have a AutoSum so when there is #values in the column it doesn't work.
Thank you in advance.
Steph
- Replace the double quotes with a 0.
4 Replies
- Most probably there is a text value in E73.
- You are correct. There is a formula in that field that pulls in a cost from another field.
=IFERROR(VLOOKUP(B73,Parts,4,FALSE),"")- Replace the double quotes with a 0.
