|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 16th, 2009, 01:29 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy A1 into C1 if B1 contains data??
I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then
c1 should remain blank. The data in a1 or b1 could be either text or numbers. As long as anything is in b1 then c1 should contain whatever is in a1. 
|
|
#2
June 16th, 2009, 01:44 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy A1 into C1 if B1 contains data??
Use this in C1:
=if(b1="","",a1) Regards, Fred "Question, Mark" wrote in message ... I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then c1 should remain blank. The data in a1 or b1 could be either text or numbers. As long as anything is in b1 then c1 should contain whatever is in a1.
|
|
#3
June 16th, 2009, 02:16 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy A1 into C1 if B1 contains data??
Excellent! I was misplacing the quotation marks.
Thank you so much. "Fred Smith" wrote: Use this in C1: =if(b1="","",a1) Regards, Fred "Question, Mark" wrote in message ... I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then c1 should remain blank. The data in a1 or b1 could be either text or numbers. As long as anything is in b1 then c1 should contain whatever is in a1.
|
|
#4
June 16th, 2009, 04:12 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy A1 into C1 if B1 contains data??
Glad I could help. Thanks for the feedback.
Fred. "Question, Mark" wrote in message ... Excellent! I was misplacing the quotation marks. Thank you so much. "Fred Smith" wrote: Use this in C1: =if(b1="","",a1) Regards, Fred "Question, Mark" wrote in message ... I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then c1 should remain blank. The data in a1 or b1 could be either text or numbers. As long as anything is in b1 then c1 should contain whatever is in a1.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
