Muliplying a number by a blank cell
 

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?

Muliplying a number by a blank cell
 

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

"Lisa" wrote:

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?

Muliplying a number by a blank cell
 

=SUM(D8*E7)

"Lisa" wrote:

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?