Formula
 

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

Formula
 

=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

Formula
 

Excellent so far but how do I get the entire column "A" to recognize the
formula for each respective cell? Meaning A2, A3, A4 etc how do I get each of
these cells to calculate B2*C2; B3*C3; B4*C4 etc

"tim m" wrote:

=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

Formula
 

After i posted the formula I realized i hadn't put that part in.

You should just have to copy if down the column as far as your data runs.
It will automatically change the formula for you. (As in it will increment
the formula from A1 B1 and C1 to A2 B2 and C2 in the formula)

"pyrenees" wrote:

Excellent so far but how do I get the entire column "A" to recognize the
formula for each respective cell? Meaning A2, A3, A4 etc how do I get each of
these cells to calculate B2*C2; B3*C3; B4*C4 etc

"tim m" wrote:

=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

Formula
 

It worked. Seems to be working fine. Thank you Tim! Just one other question,
the formula below works and gives me a total it just gives me a total in
$0.00 and $0.00 is not what I want. How do I remove the $ and just have a
value?


=COUNTIF(D3:D44,"TM")



"tim m" wrote:

After i posted the formula I realized i hadn't put that part in.

You should just have to copy if down the column as far as your data runs.
It will automatically change the formula for you. (As in it will increment
the formula from A1 B1 and C1 to A2 B2 and C2 in the formula)

"pyrenees" wrote:

Excellent so far but how do I get the entire column "A" to recognize the
formula for each respective cell? Meaning A2, A3, A4 etc how do I get each of
these cells to calculate B2*C2; B3*C3; B4*C4 etc

"tim m" wrote:

=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

Formula
 

Format the cell appropriately.
--
David Biddulph

"pyrenees" wrote in message
...
It worked. Seems to be working fine. Thank you Tim! Just one other
question,
the formula below works and gives me a total it just gives me a total in
$0.00 and $0.00 is not what I want. How do I remove the $ and just have a
value?


=COUNTIF(D3:D44,"TM")



"tim m" wrote:

After i posted the formula I realized i hadn't put that part in.

You should just have to copy if down the column as far as your data runs.
It will automatically change the formula for you. (As in it will
increment
the formula from A1 B1 and C1 to A2 B2 and C2 in the formula)

"pyrenees" wrote:

Excellent so far but how do I get the entire column "A" to recognize
the
formula for each respective cell? Meaning A2, A3, A4 etc how do I get
each of
these cells to calculate B2*C2; B3*C3; B4*C4 etc

"tim m" wrote:

=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

Formula
 

'Format'....'Cells'....'Number' tab and then chose how you want the cell to
appear.

"pyrenees" wrote:

It worked. Seems to be working fine. Thank you Tim! Just one other question,
the formula below works and gives me a total it just gives me a total in
$0.00 and $0.00 is not what I want. How do I remove the $ and just have a
value?


=COUNTIF(D3:D44,"TM")



"tim m" wrote:

After i posted the formula I realized i hadn't put that part in.

You should just have to copy if down the column as far as your data runs.
It will automatically change the formula for you. (As in it will increment
the formula from A1 B1 and C1 to A2 B2 and C2 in the formula)

"pyrenees" wrote:

Excellent so far but how do I get the entire column "A" to recognize the
formula for each respective cell? Meaning A2, A3, A4 etc how do I get each of
these cells to calculate B2*C2; B3*C3; B4*C4 etc

"tim m" wrote:

=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