Solved

# set excel cell value based on another cell

Posted on 2002-06-05

I have what seams to be simple

I wish to set A1 to the value of B1 if C1 = “TEXT”

I need to be able to use this within other functions such as if() from another cell

EG

- A1 - B1 - C1 - D1

- - 22 - A - =IF(C1=”A”,A1= value of B1,blank)

- - 23 - B - =IF(C1=”A”,A1= value of B1,blank)

- - 24 - A - =IF(C1=”A”,A1= value of B1,blank)

- - 25 - - =IF(C1=”A”,A1= value of B1,blank)

should result in

- A1 - B1 - C1 - D1

- 22 - 22 - A -

- - 23 - B -

- 24 - 24 - A -

- - 25 -

sorry for the formating. I have used '-' for cell delimiters. there are no negative numbers

thanks