Forum Discussion

Copper Contributor

Aug 23, 2020

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...

Rajesh_Sinha

Iron Contributor

Sep 24, 2020

KBCHFRE ,,,

Your formula =IF(AND(A1>0,A1<100),1,"") is the most appropriate, checks value between 1 and 99.

Also you may try these one:

=IF(AND(A1>=1,A1<=99),1,"")

Or you may use this also

=IF((A1>=1)*(A1<=99),1,"")