Thread
:
Formula HELP
View Single Post
#
4
TooSimple
Posts: n/a
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
Reply With Quote