Forum Discussion
Excel formula
Greetings, I'm seeking a formula that returns a 1 or blank if the value in the cell is >0 and <100 so 1-99=1 but 0 and 100 = blank. I have tried so many variations.... =IF(A1>0<100,1,"") =IF(A1...
The last one is the closest
=IF(AND(A1>0,A1<100),1,"")
=IF(AND(A1>0,A1<100),1,"")