Thread
:
Excel Formular
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Dave Peterson
external usenet poster
Posts: 35,218
Excel Formular
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson