Muliplying a number by a blank cell

G

Guest

I'm trying to calculate an expense report. The mileage is 0.445 and is
located in cell E7. I need to be able to set a formula to multiply the
mileage by whatever number someone puts in the "Miles" column (Cell D8).
Sometimes there will be people with miles to add, and sometimes there won't
be. When I have tried to set this up, it always puts the total as 0.445. I
have used the function: =PRODUCT(E7,D8). When I leave cell D8 blank - it
always gives a total of 0.445
Does anyone know what to do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overwriting a cell with a formula without deleting the formula 1
Payment calculation 1
Mileage Calculation 5
Entered text value equals a number I specify in another cell 3
How do I set up a conditional cell from a drop down list in Excel 3
Setting up a worksheet 1
Timecard question 5
How can I move from one desired cell to another in Excel using ENT 5

Top