Use IsBlank in array?

[normpam]

C3 D3 E3 F3 G3 H3 I3
40.00 86.00 71.00 65.00

would like to get a result 'yes' or 'no' if any cell in the range C3:I3 is empty

Tried {=IF(ISBLANK(C73:BZ73),"y","n")} but do not get a correct result. What am I missing?

Thanks!

 

[normpam]

Just noticed that when posted the cells all seem full. In fact, C3, F3 and H3 would be empty.....

 

[sandy666]

maybe

Book1
	C	D	E	F	G	H	I	J	K	L	M
3	5	7		11	13	15		19	21		Y
Sheet1

Cell Formulas
Range	Formula
M3	M3	=IF(COUNTBLANK(C3:L3)>0,"Y","N")

 

[normpam]

Thanks. I think that will help. Actually have another calculation that I need to do based on this, but was thinking the wrong way! I don't think I've ever needed CountBlank before, so didn't even think of it, but that's why it's so great to have another pair of eyeballs take a look sometimes to help!

 

[sandy666]

You are welcome

btw. update your profile (Account details) about Excel version and OS

 

[Tetra201]

... What am I missing?..

You are missing OR:

{=IF(OR(ISBLANK(C3:I3)),"y","n")}

 

[normpam]

Thanks Tetra.... I need to now incorporate that into another formula to see if it gives me what I need. Meanwhile, I was trying something else and came up with something really weird. I can use the following formula with no problem =SUM(ABS(C8:G8)), but when I use it in VBA as follows Range("B8").Value = "=SUM(ABS(C8:BZ8))" it automatically puts in an @ sign before the 'C8' every time..... why would it do that?

 

[Tetra201]

Try

Range("B8").FormulaArray = "=SUM(ABS(C8:BZ8))"