I need help with an Excel formula. I am trying to create an MPG tracker for my company vehicles, and I would like the results of a formula to remain blank until all the relevant data has been entered.
I have my starting mileage in cell B9, my ending mileage in cell C9, and my total miles in cell D9. I would like the total miles cell (D9) to remain blank until I have entered my ending mileage at the end of the day. The current Formula I have entered in cell D9 now is: =C9-B9.
![Cells Cells](/uploads/1/2/5/4/125454443/361509136.gif)
See the below screenshot.
In Excel 2007, choose Go To Special from the Find and Select dropdown list in the Editing group on the Home tab. Select Blanks. When you click OK, Excel will select all the blank cells in A2:A11. Leave the Find What field blank and enter the words No Response in the Replace With field, and then click Replace All. This will automatically fill in the blank cells with the word No Response. Figure 2: Find and Replace allows you to fill in blank cells.