excel spreadsheet

[gma]

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?

 

[Max]

If one cell has a value no matter what the value is,
i need to be able to equale the value from another cell.

Vague, but one thought
Assume A1 is your "one cell" to monitor with B1 the other cell
Then in say, C1: =IF(COUNTA(A1),B1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

 

[ShaneDevenshire]

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.

 

[gma]

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?