[h=2]
recieving information fromTwo columns[/h]

Hello, I have a worksheet problem. Column "C" is receiving information from both column "A" and column "B", and I wish the numerical value to transpose to column "C". In other words "A1" might have 1.0, column "B" would be blank, and I would like to record the 1.0 in "C1"the numerical number would only come from one or the other columns ("A" or "B") never both. So if column "B" has a number say "B2", I would like I to transpose the number to "C2"