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?