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

"Dave Peterson" wrote:

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 wrote:

Please how do i enter this formular in excel

if 0.2 < x 0.8.

--

Dave Peterson