Formula - If C2 is not blank, and b2 Is blank, then copy c2 to

Solved/Closed

Eirualmac Posts 2 Registration date Thursday July 9, 2015 Status Member Last seen July 12, 2015 - Jul 9, 2015 at 02:52 AM
Eirualmac Posts 2 Registration date Thursday July 9, 2015 Status Member Last seen July 12, 2015 - 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!

If formula not blank
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Credit summation formula - Guide

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 9, 2015 at 09:00 AM

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 Posts 2 Registration date Thursday July 9, 2015 Status Member Last seen July 12, 2015
Jul 12, 2015 at 02:20 PM

This does it!
Thanks, SO MUCH!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!