=IF(A10,B1*C1,"")

This formula looks at A1, if it is greater than zero it does the
multiplication, if not it sticks a blank on the cell.

"pyrenees33" wrote:

Does anyone know how to create a "IF THEN" formula? I need something simple
but I am getting errors. I need 2 cells to multiply each other IF another
cell is greater than 0. I need the entire column drafted for such a IF THEN
formula. So column "A" for instance from A1 through A40 lets say if any cell
in that range (lets use A12 for example) is greater than 0 then B12 x C12