Excel Formular

[Stats student]

Please how do i enter this formular in excel

if 0.2 < x > 0.8.

 

[Dave Peterson]

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.

 

[Stats student]

Thanks Dave. This was what i needed. I am really grateful