Data entry - Copy contents of cell typed in one cell to another ce

if i type the number 3 in cell b1, how can I get that value copied into cell
c3?
and then when i type in cell b2, to have that value copied into cell c3
which will overwrite the previous number copied?

Thanks,

Try this in C3



=IF(AND(ISBLANK(B1),ISBLANK(B2)),"",IF(ISNUMBER(B2),B2,B1))

This will leave C3 blank if both B1 and B2 are empty. If either B1 or B2 is not empty and if B2 is a number then it will return B2 if not it will return B1.

HTH

Steve

How should I code the syntax for more than two cells, say 7 cells B1 through
B7?

Thanks,

"SteveG" wrote:

>
> Try this in C3
>
>
>
> =IF(AND(ISBLANK(B1),ISBLANK(B2)),"",IF(ISNUMBER(B2),B2,B1))
>
> This will leave C3 blank if both B1 and B2 are empty. If either B1 or
> B2 is not empty and if B2 is a number then it will return B2 if not it
> will return B1.
>
> HTH
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=522833
>
>