Please how do i enter this formular in excel if 0.2 < x > 0.8.
D Dave Peterson Sep 10, 2009 #2 If you meant: if 0.2 < x < 0.8. One way: =if(and(0.2<a1,a1<0.8),"between .2 and .8","not between") A1 is the cell that contains x.
If you meant: if 0.2 < x < 0.8. One way: =if(and(0.2<a1,a1<0.8),"between .2 and .8","not between") A1 is the cell that contains x.
