having problems equaling other cells with values

[gma]

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?

 

[Sheeloo]

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

 

[gma]

It worked...thanks a bunch.

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