type data in one cell, it also appears in another

**OCcat** · 10-20-2012, 09:10 AM

Hello, I would like to use a formula where when a 1 is typed into one cell, a 1 also appears in another cell.
Example, type 1 into any of cells A1, A2, A3, or A4, and a 1 will also appear in cell A5.

I am not sure if this is called conditional formatting but I don't think it is very complex. I am still new to working with formulas other than =sum(). I am excited to learn other forumlas so thank you for the helP!

Solved, thank you!

**Jacc** · 10-20-2012, 11:47 AM

I played around with some formulas here. The result is not impressive but depending on your needs it could be adequate.

**FDibbins** · 10-20-2012, 12:01 PM

2 different versions...

=IF(OR(A1=1,A2=1,A3=1,A4=1),A1,"") this will give you the value of A1 if 1 is in any of the 4 cells

=IF(A1=1,A1,IF(A2=1,A2,IF(A3=1,A3,IF(A4=1,A4,"")))) this will put the value of any of the cells into A1

**Cutter** · 10-20-2012, 08:17 PM

Or

=IF(COUNTIF(A1:A4,1),1,"")

**OCcat** · 10-20-2012, 11:08 PM

Thank you everyone for this help. It works and does exactly what I want, but having this formula messes up another formula that was dependent upon some of the data that is now being calculated.
I'm going to mark this as solved because you guys got me exactly what I asked for, thank you SO MUCH!

**Cutter** · 10-21-2012, 11:49 AM

You're welcome. You didn't properly mark your thread as SOLVED so I'll do it for you. (You should have clicked on the Thread Tools button above your initial post and from the drop down selected "Mark this thread as solved".)