Hi, thanks for the reply...i didnt make the question very clear. i have set
values in one colume and in the other colume the number changes...
CELL A1 IS 500
CELL B2 IS THE FORMULA asking for the
CELL C2 IS THE CHANGING VALUE
say C3 gets a value from another range of cells, then i need B2 to recognize
this, but input the set value from A1
can you help me with this?

"ShaneDevenshire" wrote:

Hi,

If by "value" you mean a number then
=IF(B5,B10,"")
If you mean one cell, here B5, contains anything other than being blank, then
=IF(B5<"",B10,"")
where B10 contains the value you want to display if anything is in B5.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"gma" wrote:

If one cell has a value no matter what the value is, i need to be able to
equale the value from another cell. Does anyone know what to do this?