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 for example column "A" from A1 through A40 if any cell
in that range (lets use A12 for example) is greater than 0 then B12 x C12.
As each cell in column A is filled with a number greater than 0 I need the
corresponding cells (B & C) to be multiplied and added to the total. Any help
is sincerely appreciated

Is the total you mention in column A?

Are you wanting this in VBA, or just a worksheet function like:
=IF(A140,B1*C1+A1,"Column A is not greater than 40")
--
Best Regards,

Luke M


"pyrenees" wrote:

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 for example column "A" from A1 through A40 if any cell
in that range (lets use A12 for example) is greater than 0 then B12 x C12.
As each cell in column A is filled with a number greater than 0 I need the
corresponding cells (B & C) to be multiplied and added to the total. Any help
is sincerely appreciated

Hi Luke,

No the total can be anywhere really but for the sake of the argument column
D will have the total. Basically each time I enter a value in any cell in
column A I want the corresponding cells (ie IF A18 is 0 then B18*C18) and
added to the overall total. I can create a single formula for 1 cell in
column A but I do not know how to create a formula for all cells in column A
with respect to cells in B & C. Am I making any sense here or confusing the
matter more?

"Luke M" wrote:

Is the total you mention in column A?

Are you wanting this in VBA, or just a worksheet function like:
=IF(A140,B1*C1+A1,"Column A is not greater than 40")
--
Best Regards,

Luke M


"pyrenees" wrote:

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 for example column "A" from A1 through A40 if any cell
in that range (lets use A12 for example) is greater than 0 then B12 x C12.
As each cell in column A is filled with a number greater than 0 I need the
corresponding cells (B & C) to be multiplied and added to the total. Any help
is sincerely appreciated

Just to add the entire column in "A" does not have to be 0 at once but
randomly as cell in "A" is added a value greater than 0 then the
corresponding cells B & C will be multiplied.

"Luke M" wrote:

Is the total you mention in column A?

Are you wanting this in VBA, or just a worksheet function like:
=IF(A140,B1*C1+A1,"Column A is not greater than 40")
--
Best Regards,

Luke M


"pyrenees" wrote:

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 for example column "A" from A1 through A40 if any cell
in that range (lets use A12 for example) is greater than 0 then B12 x C12.
As each cell in column A is filled with a number greater than 0 I need the
corresponding cells (B & C) to be multiplied and added to the total. Any help
is sincerely appreciated

Think this might do it, placed in say, C1:
=SUMPRODUCT((ISNUMBER(A1:A40))*(A1:A400),B1:B40*C 1:C40)

If you have numbers in cols B and C, with col A initially blank, then
randomly entering any number greater than zero within col A will return the
product of the corresponding numbers in cols B and C. Eg if you enter: 1 in
say A13, then C1 returns: B13*C13.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pyrenees" wrote:
Just to add the entire column in "A" does not have to be 0 at once but
randomly as cell in "A" is added a value greater than 0 then the
corresponding cells B & C will be multiplied.