formula if all cells in a range are >x

[kitm]

Hello, I am trying to write a formula that returns a true/false result based on whether all values in a range are greater than a reference number. I've tried several combinations of IF, COUNTIF, AND, and NOT but I can't find the right combo. Example of the table below. I have the target number in the first cell, and then the actual accrued number in the rest of the row. I want to add a column at the end of the range that returns true or false if all the actual numbers are larger than the target in column A. I would also like it to disregard blank cells as this is updated in real time at the end of each day.

Daily Target	11/1	11/2	11/3	11/4	11/6	11/7	11/8	11/9	Target Met Every Day?
8	5	10

 

[Michael M]

Try using

=IF(COUNTIF(B2:I2,"")>=1,"Blanks in Range",IF(COUNTIF(B2:I2,">="&A2)=8,"True","False"))

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this do what you want?

23 11 01.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Daily Target									Target Met Every Day?
2	8	5	10							FALSE
3	5	5	10	8	6					TRUE
Target

Cell Formulas
Range	Formula
J2:J3	J2	=COUNTIF(B2:I2,">="&A2)=COUNT(B2:I2)

 

[Phuoc]

Like this?

Book1
	A	B	C	D	E	F	G	H	I	J
1	Daily Target									Target Met Every Day?
2	8	5	10							FALSE
3	5	5	10	8	6					TRUE
Sheet1

Cell Formulas
Range	Formula
J2:J3	J2	=MIN(B2:I2)>=A2

 

[kitm]

Welcome to the MrExcel board!

Does this do what you want?

23 11 01.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Daily Target									Target Met Every Day?
2	8	5	10							FALSE
3	5	5	10	8	6					TRUE
Target

Cell Formulas
Range	Formula
J2:J3	J2	=COUNTIF(B2:I2,">="&A2)=COUNT(B2:I2)

Thank you that worked!! I was close but not quite there before.

 

[Peter_SSs]

Thank you that worked!! I was close but not quite there before.

You are welcome - but did you try the even simpler suggestion in post #4?

 

[kitm]

You are welcome - but did you try the even simpler suggestion in post #4?

It didn't seem to work at first, but looks like it just needed at least one value in the range, so yeah that works too.

 

[kitm]

Like this?

Book1
	A	B	C	D	E	F	G	H	I	J
1	Daily Target									Target Met Every Day?
2	8	5	10							FALSE
3	5	5	10	8	6					TRUE
Sheet1

Cell Formulas
Range	Formula
J2:J3	J2	=MIN(B2:I2)>=A2

That worked, thank you