Thread: Data entry - Copy contents of cell typed in one cell to another ce
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Data entry - Copy contents of cell typed in one cell to another ce

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

Reply With QuoteReply With Quote