Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Formular
Please how do i enter this formular in excel
if 0.2 < x 0.8. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Formular
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formular | Excel Discussion (Misc queries) | |||
Excel Formular help | Excel Worksheet Functions | |||
Excel - What is ^ in a formular? ie +(p23)^.5 | Excel Discussion (Misc queries) | |||
what is Arp use for as formular in Excel, how to use | Excel Worksheet Functions | |||
excel formular | Excel Worksheet Functions |