When I try to multiply L7 to S7, I get errors.

Do you mean that this formula gives you an error:

=L7*S7

Does it return a #VALUE! error? If so, that means one of or both values are
TEXT. Format those cells as GENERAL then select each cell and press function
key F2 then hit ENTER. That should fix the error problem (unless there are
unseen characters like spaces in one or both cells).

What I really want to do, is, if L7 has any value in it
then I want to multiply this value by the value that is in S7.

=IF(ISNUMBER(L7),L7*S7,"")

Biff

"Ne0dammerung" wrote in message
...
What am I doing wrong with this formula?

=SUMIF(L7:L7,"0",(L7*S7))

What I really want to do, is, if L7 has any value in it
then I want to multiply this value by the value that is in S7.
If there is no value (blank cell), then I want the cell that would contain
the product to remain blank.

L7 represents quantity
S7 represents Cost Per Unit
U7 represents Total

When I try to multiply L7 to S7, I get errors. I amtrying to avoid having
many cells with the 0 (zero) value