IF THEN formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pyrenees - 14 Dec 2007 21:10 GMT

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

Reply to this Message

Luke M - 14 Dec 2007 21:37 GMT

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")

Signature

Best Regards,

Luke M

> 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
[quoted text clipped - 3 lines]
> corresponding cells (B & C) to be multiplied and added to the total. Any help
> is sincerely appreciated

Reply to this Message

pyrenees - 14 Dec 2007 21:54 GMT

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?

> Is the total you mention in column A?
>
[quoted text clipped - 8 lines]
> > corresponding cells (B & C) to be multiplied and added to the total. Any help
> > is sincerely appreciated

Reply to this Message

pyrenees - 14 Dec 2007 22:03 GMT

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.

> Is the total you mention in column A?
>
[quoted text clipped - 8 lines]
> > corresponding cells (B & C) to be multiplied and added to the total. Any help
> > is sincerely appreciated

Reply to this Message

Max - 15 Dec 2007 10:29 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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.

Reply to this Message