I'm trying to create a formula that says

"if the value in A1 is greater than 5 and less than 10" return a "1"
otherwise leave blank.

note: column A are all numeric values