software

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)),quot;quot;,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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=522833How should I code the syntax for more than two cells, say 7 cells B1 through
B7?

Thanks,

quot;SteveGquot; wrote:

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