software

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 quot;Milesquot; 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?

PRODUCT ignores blanks. Just try =e7*d8, which treats a blank cell as a 0.

quot;Lisaquot; wrote:

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

=SUM(D8*E7)

quot;Lisaquot; wrote:

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