If multiple cells empty then value

[clandestino800]

Hi all,

I’m trying to get a value C2 cell into A2. If C2 is empty, then check F2 and you if F2 is empty as well, i need the formula to return “not assigned”

I tried using IF(ISBLANK… and IF(AND(C2=“”..

The formula keeps returning “not assigned”

Please advise
Thanks

 

[6StringJazzer]

You only showed a little tiny piece of your attempted formulas so I can't tell you what's wrong.

Here are two ways to do it, showing all four combinations for C and F

$scratch.xlsm
	A	B	C	D	E	F
1	Version 1
2	Not Assigned
3			x
4						x
5			x			x
6	Version 2
7	Not Assigned
8			x
9						x
10			x			x
Sheet11

Cell Formulas
Range	Formula
A2:A5	A2	=IF(C2&F2="","Not Assigned","")
A7:A10	A7	=IF(AND(C7="",F7=""),"Not Assigned","")

 

[Micron]

maybe
=IF(AND(ISBLANK(C2),ISBLANK(F2)),"not assigned",C2)

 

[6StringJazzer]

I think I'm unclear as to what results you want. After seeing Micron's post, I think that if C2 is not blank, you want the formula to return V2. But if C2 is blank and F2 is not, do you want the result to be F2?

 

[clandestino800]

I think I'm unclear as to what results you want. After seeing Micron's post, I think that if C2 is not blank, you want the formula to return V2. But if C2 is blank and F2 is not, do you want the result to be F2?

yes, exactly. If C2 is empty but F2 is not,
it should return F2, if neither “not assigned”

I think I'm unclear as to what results you want. After seeing Micron's post, I think that if C2 is not blank, you want the formula to return V2. But if C2 is blank and F2 is not, do you want the result to be F2?

 

[6StringJazzer]

OK this will do it:

=IF(C2<>"",C2,IF(F2<>"",F2,"Not assigned"))

$scratch.xlsm
	A	B	C	D	E	F
2	Not assigned
3	1		1
4	2					2
5	3		3			4
Sheet11

Cell Formulas
Range	Formula
A2:A5	A2	=IF(C2<>"",C2,IF(F2<>"",F2,"Not assigned"))