I have a Google Sheets which basically looks like this:
Enter a number: cell1here
Enter another number: cell2here
Cell2 number converted to correct units: cell3here (cell2 * cell 8)
total: cell4here (cell2 divided by cell1)
So basically the user just needs to enter a number in cell1 and cell2, and other numbers will show up in cell3 and cell 4.
But when I keep cell1 and cell2 blank, I get an error in cell4, saying #DIV/0. But, when cell1 and cell2 are blank I just want cell4 to show 0.00 instead. Is this possible, if so how can I do this?