Formula looking at two separate cells resulting in one cell

[jkr4250]

Alright so Im not too sure how to word this but, I am looking to use a formula that will be linked to three cells total.

Ill use A1, A2 and B1

If A1 or A2 has a value entered in the cell i would like B1 to equal that value.

A1= 2
A2= (blank)

Then B1= 2

and Vice Versa

Thanks again for your time,

Jeff R.

[rcm]

enter this in b1

Please Login or Register  to view this content.

[jkr4250]

Thank You so much you ROCK!!