IF THEN formula
 

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

IF THEN formula
 

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

IF THEN formula
 

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

IF THEN formula
 

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

IF THEN formula
 

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.