having problems equaling other cells with values
 

Ok my problem is I need to equale or copy a number/value from one cell and
put it into another cell that has the "formula", but only if the cell in
question gets a number/value from a range of cells. Let me try and put it
like this also:

Cell A1 is "500" and is the
Cell B2 is the cell and formula that I want the number from "colume A" to go
to but only if,
Cell C3 gets a value other than "0" from another range of cells, then i need
B2 to recognize this, and input the set value from A1 into B2
can anyone help me with this?

having problems equaling other cells with values
 

Put this in B2
=IF(C3<0,A1,"")

This will put the value from A1 in B2 only if C3 is not zero, otherwise it
will leave B2 empty...


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"gma" wrote:

Ok my problem is I need to equale or copy a number/value from one cell and
put it into another cell that has the "formula", but only if the cell in
question gets a number/value from a range of cells. Let me try and put it
like this also:

Cell A1 is "500" and is the
Cell B2 is the cell and formula that I want the number from "colume A" to go
to but only if,
Cell C3 gets a value other than "0" from another range of cells, then i need
B2 to recognize this, and input the set value from A1 into B2
can anyone help me with this?

having problems equaling other cells with values
 

It worked...thanks a bunch.

"Sheeloo" wrote:

Put this in B2
=IF(C3<0,A1,"")

This will put the value from A1 in B2 only if C3 is not zero, otherwise it
will leave B2 empty...


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"gma" wrote:

Ok my problem is I need to equale or copy a number/value from one cell and
put it into another cell that has the "formula", but only if the cell in
question gets a number/value from a range of cells. Let me try and put it
like this also:

Cell A1 is "500" and is the
Cell B2 is the cell and formula that I want the number from "colume A" to go
to but only if,
Cell C3 gets a value other than "0" from another range of cells, then i need
B2 to recognize this, and input the set value from A1 into B2
can anyone help me with this?