Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BLANK cell TO A NUMBER | Excel Discussion (Misc queries) | |||
select cell based on a number in another cell | New Users to Excel | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |