formula help

[Guest]

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

 

[Bryan Hessey]

=if(and(A1>5,A1<10),1,"")

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 value

 

[Guest]

yes, and you're right too simple....thank you!!!

Will this work for you?

=IF(AND(A1>5,A1<10),1,"")