Formula - If C2 is not blank, and b2 Is blank, then copy c2 to [Solved/Closed]

Eirualmac 2 Posts Thursday July 9, 2015Registration date July 12, 2015 Last seen - Jul 9, 2015 at 02:52 AM - Latest reply: Eirualmac 2 Posts Thursday July 9, 2015Registration date July 12, 2015 Last seen
- Jul 12, 2015 at 02:20 PM
Hi all -
Am looking for help on formula -
I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If B2 does not = the letter "C" (b2 will only have one letter or will be blank), or it is "blank", then to copy the contents of c2 to c47. Of course, if C2 is blank, then do nothing.
I'm doing something wrong, obviously - I've tried If/than & isblank formulas but can't seem to structure it correctly.
Thanks!
See more 

2 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jul 9, 2015 at 09:00 AM
0
Thank you
Eirualmac, Good morning.

Try to use:

C47 --> =IF(C2<>"",IF(OR(B2<>"C",B2=""),C2,""),"")

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Eirualmac 2 Posts Thursday July 9, 2015Registration date July 12, 2015 Last seen - Jul 12, 2015 at 02:20 PM
This does it!
Thanks, SO MUCH!