IF function not working

[mrm]

IF function not working =IF(E6:E10=35,35," ") range contains 35
but result displayed is #VALUE!

[erAck]

The expression E6:E10=35 in your case does an implicit intersection of the position of the formula cell and the vector E6:E10, so if the formula cell is on one of the rows 6 to 10 there would be a result of column E with the very same row, but on any other row it returns a #VALUE! error.
See also Array Functions Implicit intersection of array formulas.

[LeroyG]

Try with =IF(SUMIF(E$6:E$9;35);35;"")
Also works with COUNTIF.