IF THEN formula

  • Thread starter Thread starter pyrenees
  • Start date Start date
P

pyrenees

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(A1>40,B1*C1+A1,"Column A is not greater than 40")
 
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?
 
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.
 
Think this might do it, placed in say, C1:
=SUMPRODUCT((ISNUMBER(A1:A40))*(A1:A40>0),B1:B40*C1: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.
 
Back
Top