formula help
 

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

=if(and(A15,A1<10),1,"")

LRabourn Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476125

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

"TooSimple" wrote:

Will this work for you?

=IF(AND(A15,A1<10),1,"")


"LRabourn" wrote:

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